Upgrading SQL 2008 R2 Editions – Wizard and Command Line

14th May 2013 0 By Simon

During a recent Microsoft True-Up piece of work we were doing at work we discovered that 3 of our Microsoft SQL servers had been installed with the Developer edition of Microsoft SQL 2008 R2, this isn’t really an issue because we are licensed for the proper versions but to make life easier for us in the future we decided to upgrade the instances to the correct version now rather than run into this same issue again in the future.

Now there are a couple of ways of doing this but both methods require the installation media and the PID from the target version to hand.

In this guide I will be upgrading from SQL 2008 R2 Standard to Enterprise Edition.

image

GUI Wizard Upgrade

The first of the upgrade methods uses the Installation Wizard to carry out the upgrade.

Run the Setup.exe file to bring up the Installation Wizard.

image

Click onto the Maintenance Option and click Edition Upgrade.

image  image

Click through a couple of Setup Rule screens.

image

At this screen you need to enter the new Product Key for the version of SQL that you want to upgrade to.

image

Accept the license terms.

image

Select the SQL Instance to upgrade.

image

Run through the Upgrade Rules check.

image

We can see that we are going to upgrade to Enterprise edition in this screen.

image

After a few minutes the upgrade was complete and launching SQL Management Studio and checking the properties now shows an upgraded SQL Server.

Command Line Upgrade

Open up a command prompt and browse to the folder containing the SQL Server Installation media.

image

Run the following command to upgrade the edition of SQL.

Setup.exe /q /ACTION=editionupgrade /INSTANCENAME=MSSQLSERVER /PID=”<PID key for new edition>" /IACCEPTSQLSERVERLICENSETERMS

In a matter of seconds your version of SQL Server will change to the required version.

image

A much quicker and simpler way of upgrading the edition of SQL Server Smile