Posted by Erland Sommarskog on 07/20/07 21:23

Erwin Moller (since_humans_read_this_I_am_spammed_too_much@spamyourself.com)
writes:
> I think I'll switch to SQL Express 2005.
> One last question: If I switch to SQL Express 2005, do you expect that I
> can copy the database from MSSQL2000 to SQL Express 2005 without scripts
> and bulk data load?

Yes. You can copy with attach/detach or BACKUP/RESTORE. Note that you
cannot copy back this way. This must be done with scripts and bulk load.

Also, be sure to run sp_updatestats when you have copied the database
to SQL 2005, as the migration invalidates all statistics.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]