Migrating from Sql Server Express 2005 to express 2008
Please advice on doing this migration, are there any issues I should be aware of. Can I do an in-place migration of the server or side-by-side?
Solution 1:
Run the SQL Server Upgrade Advisor to check for any compatibility issues.
You can do side-by-side or in place.
Attaching 2005 database files to 2008 will upgrade them.
Solution 2:
I've migrated about half a dozen systems and had no issues.