Unanswered: Moving from SQL Express 2k5 to SQL Server 2k5
What is the best way to move a SQL Server Express 2k5 database to a SQL Server 2005 (standard) server? Would I simply just detach the database and logs, copy them to the new server, then reattach them? Thanks!
It would be better to back up the databases on the Express server then restore them on the standard version.
Be aware that there are some subtle differences in a few T-SQL instructions and their syntax between the two versions, so carefully check the stored procedures and functions (if any) before validating the migration.