February 11, 2004 at 9:37 am
I have a good sized task ahead. We have 2 seperate SQL server boxes. Box 1 has about 12 production databases and box 2 has 2 or 3 production database. Each database does has it own by different applications.
I need to move all the databases (including logins, users, jobs, dts packages, etc) from both boxes to one server. What is the best way to complete this task? Are there automated tools available. I have looked at SQL Compare and DTS Compare from Red-Gate, but it does not look like it will sync jobs, logins, dts packages between servers.
By the way, I am not a DBA, so the any suggested help will have to be specific.
Thanks!
Jeff
February 11, 2004 at 10:17 am
1. To move databases, use backup/restore or sp_detach_db/sp_attach_db
2. Move logins, http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k
3. To move jobs, script all jobs and apply it to new server.
4. Open each DTS package at source server and save them to the destination server. You may have to make all necessary changes.
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql2k
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply