December 15, 2006 at 2:23 am
Hello
Whats the best approach to move all dbs and users from sqlserver 2000 to 2005?
a) detach/attach dbs, Script to extract users/pw with sid
b) backup / restore
c) ??
Thanks for a tip.
Jan
December 15, 2006 at 11:57 am
Depends. Detach / attach works and backup/restore works fine. In my workings I have typically gone with backup restore when I have moved from SQL 7 to 2000 or simply replace server hardware. There are a few pros and cons to each but not a great difference as they accomplish the same thing really. If you have a very large db the detach/attach will be quicker.
December 15, 2006 at 12:08 pm
To minimize the down time:
If you are installing sql 2005 on new server to migrate from different sql 2000 box... Backup/Restore will reduce the down time...
If you are installing sql 2005 on the same server as different instance... Attach/Detach will be faster...
In either case you should keep valid SQL 2000 backup incase you want to roll it back because you can reattach/restore 2005 databases to 2000.
http://msdn2.microsoft.com/en-us/library/ms144267.aspx
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133/
MohammedU
Microsoft SQL Server MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply