Rotating Header Image

SQL Server 2005 Edition Upgrade

As most of my posts are inspired by stuff I’ve been working on or have worked on recently this is no different.

A request came in to upgrade a SQL Server 2005 Standard Edition Instance to a SQL Server 2005 Enterprise Edition Instance.  Funny thing is that I’ve been working with SQL Server 2005 since it’s release and haven’t had to do this before… weird… so I setup a test box with 2005 STD to play around with and mounted myself a 2005 ENT Edition ISO and ran the GUI setup.

After a bit the wizard told me that in order to upgrade my edition of SQL Server I needed to install via command line and use the SKUUPGRADE switch.

So I googled myself some Books Online goodness cause installing SQL from the command line is not something I do everyday LOL and found this:

How to: Install SQL Server 2005 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx

 [SKUUPGRADE]
Use the SKUUPGRADE parameter when upgrading from one edition of SQL Server to another edition of SQL Server.

Important: 
If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.
 

To perform an edition upgrade of a default instance of SQL Server (SQL Engine only) via unattended Setup, run the following command using either /qb or /qn:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

The /qb switch allows display of basic Setup dialog boxes. Error messages are also displayed.

The /qn switch suppresses all Setup dialog boxes and error messages. If the /qn switch is specified, all Setup messages, including error messages, are written to Setup log files.

 

 So before doing this I took note of the Service Pack + Hotfix level so that I could reapply them after the edition upgrade was complete.

I ran the script as indicated (after a full backup of course) and it worked like a charm.  After reapplying the service pack + hotfixes required to get me back to the same version the users tested and all went as expected.

Not sure how I avoided doing an edition upgrade in the last 5 years or so but it was fun to do something with SQL that was new to me.

and just in case you missed it…

Important: 
If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.

 

Enjoy!!

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

2 Comments

  1. If you share your Riff to Facebook, it will be embedded directly into your timeline for all to see. Notably, while Riffs appear as Flash objects on desktop computers, they play just fine in the Facebook iPhone app.

  2. Tarun Pathak, senior analyst at Counterpoint Research, also back’s Tripathi’s theory but said that Google’s Pixel success story in terms of hardware and specifications goes to HTC

Leave a Reply

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.