asked
SQL Server 2008 to 2008 R2 Upgradation
Hi, Is it possible to upgrade SQL Server 2008 Enterprise Evaluation to Sql Server 2008R2 Express Edition.
That sounds like a downgrade but still an upgrade, and it also sounds like something I would consider not doing even if it was supported. **Edit** I tried to upgrade SQL 2008 Standard to SQL 2008 R2 Express and got the following error: *FeatureUpgradeMatrixCheck - Checks whether the specified feature meets SQL Server 2008 R2 upgrade requirements. The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 R2 version and edition upgrade matrix in Books Online.* **Edit** If you are going in production with this, I would uninstall first: - Take a backup of your databases. - Script out all logins, jobs and other objects that you need. - Script out all backup and maintenance jobs. - Uninstall Evaluation Edition. - Install Express Edition. - Restore backups. - Restore logins and other objects. - Create a task in windows that runs your backups/maintance scripts via sqlcmd (or do powershell if you prefer that. - Sleep with no worries.
With all that going on, I would recommend doing a side-by-side, rather than in-place. Makes it easier to pick up on something you've forgotten...
agreed, uninstalling before the other server is in place leaves you with no escape route if the new server installation goes wrong. I would leave **step 4 - Uninstall Evaluation Edition.** until the very last, if I did it at all. It wont hurt being on the server and stopped.
16 People are following this question.
