Re: transfer
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/27/04
- Next message: GKramer: "GK - Granting on all objects but not on JOBs ?????"
- Previous message: Hari: "Re: Transfer Logins"
- In reply to: mike: "transfer"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 27 Feb 2004 10:30:41 +0530
Hi,
Assumption that destination is also SQL 6.5
1. Backup the database (Use Dump database dbname to
disk='c:\backup\dbname.dmp' with init)
2. Copy this dbname.dmp to destination server
3. Load the database (Load database dbname from
disk=''c:\backup\dbname.dmp')
4. BCP OUT the syslogins table from source server (In the BCP out file
delete the system logins and other unwanted users)
5. Copy the file to destination server and BCP IN to syslogins table.
Thanks
Hari
MCDBA
"mike" <anonymous@discussions.microsoft.com> wrote in message
news:2b2901c3fca3$4736fa40$a301280a@phx.gbl...
> how do i export databases and logins from one sql 6.5 to
> another? if i transfer does it mean i'm moving the
> database actually?
- Next message: GKramer: "GK - Granting on all objects but not on JOBs ?????"
- Previous message: Hari: "Re: Transfer Logins"
- In reply to: mike: "transfer"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
