Migrate SQL 2008 Enterprise to SQL 2008 Standard


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?

more ▼

asked Sep 13, 2010 at 05:40 AM in Default

avatar image

Felipe Silva
87 9 9 13

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Sep 13, 2010 at 05:45 AM

avatar image

26.2k 18 37 48

Does the key control the features available for installation then? I wasnt aware of this . . .

Sep 13, 2010 at 05:49 AM Fatherjack ♦♦

If i install with Standard Edition Key, the features will be of Standard Edition?

Sep 13, 2010 at 05:57 AM Felipe Silva

@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.

Sep 13, 2010 at 06:03 AM WilliamD

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

Sep 13, 2010 at 07:04 AM Tim
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Sep 13, 2010 at 05:47 AM

avatar image

40.9k 39 94 168

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 13, 2010 at 05:40 AM

Seen: 3178 times

Last Updated: Sep 13, 2010 at 06:18 AM

Copyright 2018 Redgate Software. Privacy Policy