So if you have SQL Server Enterprise Edition and you want to change to Standard Edition, a simple SKUUPGRADE isn’t going to work for you.
![sql server 2012 enterprise edition features sql server 2012 enterprise edition features](https://image.slidesharecdn.com/advantagesofenterpriseedition-100602011423-phpapp02/95/microsoft-sql-server-benefits-of-enterprise-edition-presentation-16-728.jpg)
But you can’t necessarily go from a more expensive version to a cheaper version. The way I usually remember the rules is that you can typically change from a cheaper version to a more expensive version. What Goes Up Does Not Necessarily Come Down Document everything you need to know about your configuration just in case something goes wrong and you’ve got to reinstall. And always, always, always take your backups and make sure they’re on separate storage before you start. The fact that it’s relatively simple isn’t an excuse to skip testing: always run through this outside of production first so you know exactly what to expect.
![sql server 2012 enterprise edition features sql server 2012 enterprise edition features](https://www.mssqltips.com/tipimages2/4391_Enterprise_features.jpg)
You can also do this from the command line using the SKUUPGRADE parameter (and back in SQL Server 2005 and prior, that was your only option).Ĭhanging the edition causes some downtime, but it’s a simple procedure. ( No, I’m not showing a screenshot with my key in it!)
Sql server 2012 enterprise edition features license key#
Protip: The Edition Upgrade GUI lets you see and copy the current license key for that instance of SQL Server. “How complicated can this be?” … Famous Last Words You run SQL Server Setup and just follow the steps in the Procedure section here. If you want to make a supported edition change, it takes a little downtime but isn’t all that tricky.
![sql server 2012 enterprise edition features sql server 2012 enterprise edition features](https://www.itprotoday.com/sites/itprotoday.com/files/styles/article_featured_retina/public/uploads/2012/02/sqlcode595x335_0.jpg)
Sometimes Edition Upgrades (SKUUPGRADES) are simple The answer is well documented by Microsoft, but it seems to be really hard for folks to find! If you’d like to go straight to the source, everything I’m going to highlight here comes from the MSDN page Supported Version and Edition Upgrades. “Enterprise Edition was installed for SQL Server, but it turns out that we only have a license for Standard Edition.