Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 2,050,846 hits
  • Select GETDATE()

    June 2011
    M T W T F S S

Help : Can I Upgrade SQL Edition without reinstall?

Posted by blakhani on June 3, 2011

And answer is “it depends”. Well, I have seen posts in forum asking steps to upgrade SQL Standard to SQL Enterprise OR SQL Developer to SQL Standard etc. So I am writing this blog to bring some clarity in steps to be performed.
First of all, refer below matrix to know if in place edition upgrade is possible or not. (SQL Server 2008 R2) (SQL Server 2008) (SQL Server 2005)

Above links are for version upgrade as well as edition upgrade. Now, if matrix says you can upgrade from edition X to edition Y then steps are pretty simple.
For SQL 2008 and SQL 2008 R2:

  • Run setup.exe from media.
    • If you have SQL already installed then you can also launch “Installation Center” by going to Start->Programs ->Microsoft SQL Server 2008[R2]->Configuration Tools-> SQL Server Installation Center[(64-bit)].
  • You would get below screen titled “SQL Server Installation Center”
  • Go to “Maintenance” and click on “Edition Upgrade”

  • Go through the Wizard and choose the Instance you want to upgrade.

It would hardly take few minutes to upgrade and I have done with many customer.

One question which was asked many times is where the hell is the key which i should enter. If you have media, look for DefaultSetup.ini file and you would find PID there.

For SQL 2005:
I would update this post once I take screenshot from SQL 2005 setup.

Balmukund Lakhani


5 Responses to “Help : Can I Upgrade SQL Edition without reinstall?”

  1. Siva said

    New blog, Good Initiative. Bookmarked it in my blog. Looking forward for good learning. Best of luck.

  2. blakhani said

    Thanks Siva. Nice to see you around.

  3. Vincent said


    Thank you for your procedure.

    I did the update of SQL 2008 R2 SP1 Express Edition with Advanced Services to Standard Edition.
    but even after restarting the server, the query “SELECT @ @ VERSION;” tells me that the Express version is still installed.

    Can you help me?


  4. […] I have already written a blog on that. Can I Upgrade SQL Edition without reinstall? […]

  5. […] upgrading edition of SQL Server is easy (my earlier blog) and downgrade is not “so” easy. We are calling it as “downgrade” because its not listed as […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: