I want to upgrade SQL 2005 to 2008, i don't want to do in-place migration directly.
we are planning Side by Side Migration only in the Production.
would it work ? if i do in-place migration from SQL 2005 to SQL 2008 for DB Engine Service only,
here my question is... would it change the SQL 2005 System Databases to SQL 2008 format ?
if it is work then i can take the above system databases backup and simply restore into Production SQL 2008.
Any suggestions would be appreciate.
When you do an in-place upgrade of the DB Engine from SQL 2005 to SQL 2008 the system databases will be upgraded. It can be a valid option for DEV and TEST environment, but be aware the rollback procedure will be quite difficult/extensive. If possible a side-by-side migration is more preferrable.
When you do the side-by-side upgrade on production environment there is NO need to restore the system databases from the DEV/TEST environment. The system databases contain instance-specific information and a restore on another instance could bring the instance down. For the side-by-side upgrade on production environment all you need to do is to restore the user databases, set compatibility level, update usage and statistics, etc.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **