question

Felipe Silva avatar image
Felipe Silva asked

Migrate SQL 2008 Enterprise to SQL 2008 Standard

Friends, I installed SQL Server 2008 Enterprise Edition in my database server because i didn´t have a SQL Server 2008 Standard DVD. There is simple anyway to "downgrade" version to Standard Edition?
sql-server-2008upgradeinstallationdowngrade
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
It is not possible to do a downgrade as far as I know. An ***upgrade*** is not a problem. You should know that the DVD edition is not important. You can use the Enterprise Edition DVD just enter the Standard Edition key at install time, and only Standard Edition will be installed.
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Felipe Silva - Yes, that is how I have experienced this in the past. As TRAD says, you will have to re-install your SQL Server now to get the right edition, but you can still use the Enterprise Edition DVD, just enter the Standard Edition key when asked and it will install Standard Edition. @Fatherjack - The way that I understand it, yes (I have used developer edition to install other editions before by entering a different key). The key "unlocks" the features that that edition should have. The install screen, especially the EULA, displays the edition you are installing. You can then go back one step and use a different key and see a different edition listed in the EULA. ***I think this was an MSDN DVD image though, so that may be the reason for it working that way.***
1 Like 1 ·
Does the key control the features available for installation then? I wasnt aware of this . . .
0 Likes 0 ·
If i install with Standard Edition Key, the features will be of Standard Edition?
0 Likes 0 ·
I have researched a bit more and 2008 is just like 2005 with respect of downgrading. Script out all your user objects and databases, uninstall EE, reboot, install Standard Edition then attach or restore your user DB's, import all your user objects from your scripts. Lengthy process but pretty simple to do. Best of luck. TRAD
0 Likes 0 ·
Tim avatar image
Tim answered
I haven't done this with SQL 2008 however I have plenty of times with 2000 and 2005, the only option then was to uninstall the instance and reinstall. There are lots of articles out there detailing step by step what to do. Just make sure you have all your jobs, users, SSIS, etc scripted out.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.