In place upgrade from Standard edition to Enterprise edition

Seeder question: If I have a Standard edition instance running on one of my production servers, but I wish to upgrade to Enterprise edition, can I do the upgrade in place? Or would I have to backup my databases, uninstall Standard, install Enterprise before finally restoring my databases?

If I can do an in place upgrade, are there any particular pit falls to look out for?

Edit: Obviously backups would be taken whatever the upgrade strategy ;)

more ▼

asked Oct 15, 2009 at 09:38 AM in Default

Ben Adderson gravatar image

Ben Adderson ♦♦
361 5 7 8

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

3 answers: sort voted first

Yes. You can do an in place upgrade.

From How to: Upgrade to a Different Edition of SQL Server 2008 :

To upgrade to a different edition of SQL Server 2008 1.Insert the SQL Server installation media. From the root folder, double-click setup.exe or launch the SQL Server Installation Center from Configuration Tools. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.

2.To upgrade an existing instance of SQL Server 2008 to a different edition, from the SQL Server Installation Center click Maintenance, and then select Edition Upgrade.

3.If Setup support files are required, SQL Server Setup installs them. If you are instructed to restart your computer, restart before you continue.

4.The System Configuration Checker runs a discovery operation on your computer. To continue, click OK.

5.On the Product Key page, select a radio button to indicate whether you are upgrading to a free edition of SQL Server, or whether you have a PID key for a production version of the product. For more information, see Editions and Components of SQL Server 2008 and Version and Edition Upgrades.

6.On the License Terms page, read the license agreement, and then select the check box to accept the licensing terms and conditions. To continue, click Next. To end Setup, click Cancel.

7.On the Select Instance page, specify the instance of SQL Server to upgrade.

8.The Edition Upgrade Rules page validates your computer configuration before the edition upgrade operation begins.

9.The Ready to Upgrade Edition page shows a tree view of installation options that were specified during Setup. To continue, click Upgrade.

10.During the edition upgrade process, the services need to be restarted to pick up the new setting. After edition upgrade, the Complete page provides a link to the summary log file for the edition upgrade. To close the wizard, click Close.

11.After installation, the Complete page provides a link to the summary log file for the installation and other important notes. To complete the SQL Server installation process, click Close.

12.If you are instructed to restart the computer, do so now. It is important to read the message from the Installation Wizard when you are done with Setup. For information about Setup log files, see How to: View and Read SQL Server Setup Log Files.

more ▼

answered Oct 15, 2009 at 11:25 PM

Jim B gravatar image

Jim B
102 1 1 2

Thanks Jim, do you have any experience of the process? I'm still wondering whether there are any particular pitfalls/issues that I ought to be aware of when going through this process.
Oct 16, 2009 at 05:41 AM Ben Adderson ♦♦
(comments are locked)
10|1200 characters needed characters left

I know this isn't anywhere near the answer, but I would backup my databases, regardless of whatever the answer is!

more ▼

answered Oct 15, 2009 at 10:13 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

(comments are locked)
10|1200 characters needed characters left
How to do this on server core?
more ▼

answered Mar 11, 2013 at 03:34 PM

SDC gravatar image


Best to ask this as a new question rather than as an answer to a 2 year old question
Mar 11, 2013 at 03:48 PM KenJ
(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: Oct 15, 2009 at 09:38 AM

Seen: 26149 times

Last Updated: Mar 11, 2013 at 03:48 PM