Upgrading SQL Server 2008 Standard to Enterprise Edition

Posted: (EET/GMT+2)

 

I recently had the need the add more features into one testing server I have. The server is running SQL Server 2008 Standard, but I needed features only available in the Enterprise Edition. Sounds simple enough, but I noticed that it wasn't as easy as just putting the Enterprise DVD on the drive and then doing an upgrade.

That is, since I already had an instance of Standard Edition installed, the Enterprise Edition setup only offered to install another instance of Standard Edition. I think I could have entered the product key for Enterprise Edition during the setup to get the setup install Enterprise instance directly, but as the MSDN medias re pre-pidded (have the serial numbers ready), I never took a record of the different keys. Until now, that is.

In the end, I ended removing the old Standard installation completely, and then re-installing Enterprise. Took a while, but sometimes these things do. Of course, all this sounded like a sub-optimal solution. So, if you know a better solution (now I have the Enterprise product key), don't hesitate to let me know. Thanks!