Edition Upgrade SQL Server 2014
Edition Upgrade SQL Server 2014
This article discusses the upgrade edition of SQL Server 2014.
In this particular scenario, it has installed a standard edition of SQL Server 2014 and want to upgrade to Enterprise Edition to enjoy the full features of SQL Server.
To check compatibility updates between editions we can see this article:
https://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx
As we can see in the article, we can upgrade from the standard to the enterprise or bussiness intelligence edition:
| SQL Server 2014 Standard 2 | SQL Server 2014 Business Intelligence
SQL Server 2014 Enterprise (Server+CAL or Core License) |
First we will show the lab setup, we have a standalone server with the following features:
– Windows Server 2012
– SQL Server 2014 Standard Edition
– It is not in the domain, the server is in a workgroup
To check the edition of SQL Server we have installed, we can use the following query:
https://sqlreview.files.wordpress.com/2016/05/1.png?w=620
We started running the SQL Server Installation Center:
https://sqlreview.files.wordpress.com/2016/05/2.png?w=620
In the left panel, we have to choose the maintenance option and the first option Edition Upgrade:
https://sqlreview.files.wordpress.com/2016/05/3.png?w=929
Now it’s time to enter the product key of the Edition we want to upgrade, in this case, Enterprise Edition:
https://sqlreview.files.wordpress.com/2016/05/4.png?w=929
In the next step we have to accept the license terms:
https://sqlreview.files.wordpress.com/2016/05/5.png?w=929
The system checks the edition upgrade rules:
https://sqlreview.files.wordpress.com/2016/05/6.png?w=929
Now we have to select the instance to upgrade the edition, in this case we select default instance:
https://sqlreview.files.wordpress.com/2016/05/7.png?w=929
Now the system checks features rules:
https://sqlreview.files.wordpress.com/2016/05/8.png?w=929
And we can verify the SQL Server 2014 features that will be changed in the next screen:
https://sqlreview.files.wordpress.com/2016/05/9.png?w=929
When the upgrade process is complete, we can review the information about the setup operations and next steps:
https://sqlreview.files.wordpress.com/2016/05/10.png?w=929
If we run the query again ”select @@version”, we can see that the changes have been applied:
https://sqlreview.files.wordpress.com/2016/05/11.png?w=620
This is a very simple process.
Note: There is no downgrade option once you are in enterprise Edition, you may receive this error in the features rules validation step if you try for example change to a Standard Edition:
https://sqlreview.files.wordpress.com/2016/05/12.png?w=929
Resources:
— Verify if your databases have enterprise features (https://msdn.microsoft.com/es-es/library/cc280724(v=sql.120).aspx)
SELECT * FROM sys.dm_db_persisted_sku_features
— Verify the sql server edition
SELECT @@VERSION