SQL Server Performance Forum – Threads Archive

Move SQL 2000 database to SQL 2005

I have a question regarding the abovementioned subject. I’ve been asked if it is difficult to take SQL 2000 databases, and ‘move’ it to a SQL 2005 server. We currently have the development server which is running on 2000. We want to move those databases to a server that has already been installed with 2005. Is it possible, and what are the steps? I think you kindly in advance for ANY help…

Hi,
Take backup of 2000 databases and restore it on 2005 server.
That’s it, all db’s will be online on 2005 server.
Only DTS packages, jobs and user logins will needs to be taken care of.

I would suggest to take route of Upgrade and you can get hands by taking help of Upgrade advisor in this case.
http://msdn2.microsoft.com/en-us/ms144256.aspx
http://www.databasejournal.com/features/mssql/article.php/3595276
http://www.microsoft.com/downloads/…6B-7E05-4322-A677-95AB44F12D75&displaylang=en – to download. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Thank you very much! You guys gave me all the information I needed. P.S. I found a stored procedure that helps you move your logins from one server to another (even from 2000 to 2005). Now I’m set. It’s called sp_help_revlogin. Regards…

Make sure to checkhttp://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx update on that script in SQL 2005. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>