SQL Server Performance Forum – Threads Archive
move db to sql 2005I am tasked to move a database from sql 2000 to sql 2005. Though my research suggests that I can backup a sql 2000 db from enterprise manager and restore it with sql 2005 management studio. what about logins? how do you transfer those?
Yes … u can use BACKUP/Restore Method to transfer/migrate dbs from SQL Server 2000 to SQL Server 2005. To transfer login referhttp://support.microsoft.com/kb/246133 After restoration in 2005… Update Statistics and run DBCC DBReindex … Madhu
yes, backup and restore would be the safest option. How about running a script for users. when you can restoring a db from sql 2000 to sql server 2005, schema will be created by tthe users names. for example, if you have a userA, there will be a schema called userA which will be owned by userA, In case you need to drop the userA, you have to drop the relevent schema as well. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
I would like to suggest to take a note of Upgrade Advisor in SQL 2005 to get you more in hand information the databases you are trying to upgrade, refer to the books online for more information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.