Craig


I just installed SQL 2005 on a new box. I want to move a database from a SQL 2000 server to the new server. Can I detach the database, copy it and attach it in the new server without having problems

I'm concerned that if the datafile is in SQL2000 format, when I connect it to SQL2005 server, will it still be in old format or will it upgrade ....or is this something you don't worry about....and why

Thanks,

Craig




Re: Upgrading 2000 to 2005, can I just move data file?

Michael Hotek


Yes, this is supported. When you attach a 2000 database to SQL Server 2005, it will run it through the upgrade process and the format will change to the SQL Server 2005 on disk format.





Re: Upgrading 2000 to 2005, can I just move data file?

Arnie Rowland

Yes, you can DETACH from SQL 2000, and move the data file (and Log file) to SQL 2005, then ATTACH. It will maintain Compabitility level 8.0 (SQL 2000) -but once attached, it cannot be move back to SQL 2000.

However, a Backup/Restore is the 'best' option.

If SQL Logins are used, you will have to migrate those as well.