SQL Server Performance Forum – Threads Archive

Migrate Databases

I have to migrate several databases from sql 2000 to yukon. What do you advise?
Copy .mdf and re-attach it in yukon?
Or is there another better way? Thanx.

I would suggest to perform version upgrade rather than going direct route. Refer to the SQL server 2005 books online for complete information on performing this task.
As SQL2k5 is still in beta it will good to know other features enlisted. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

But I want to migrate just a couple of databases, not the complete server. I’ll leave the "old" server running and wnat to do some testing in Yukon.
The "old" server is the productive one and it will still be until finish testing with the new one.

Backup and restore is a good option.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Yes you can choose set of databases to upgrade as its possible in previous versions. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I was able to completely unistall SQL 2000 and then install SQL 2005 and attach the databases without any issues. I did detach them before uninstalling 2000.

]]>