November 5, 2013 at 3:33 am
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.
November 5, 2013 at 6:37 am
sreenubabu.s (11/5/2013)
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply