0

SQL Server Upgrades – Rules & Restrictions

Hello Friends, Today we will discuss about rules according to which Sql server upgrades are possible. These operations can be edition specific or version specific.

It is not possible to upgrade any edition, version without any rules or restrictions. There are some set of rules.
Let’s see how this works.

Edition Upgrades

Most of the time organization make decisions about edition of Sql server based on the requirements which it has at that point of time. It chooses the edition which is minimum to fulfill all the requirements. But later in time when organization grows, it needs to expand its business, data and Sql server edition also to get more features.

You can get more information about features which are available in different editions here.

However this is considered a wise decision to install lower edition based on the current set of requirements but sometime it has its downsides also. When organization choose to upgrade to higher edition then it may need to upgrade its infrastructure also to get the full benefits of all the features which higher edition offers. Due to this additional cost sometime organizations opt to install higher edition at the first step to avoid any additional cost in between.

You can upgrade all editions of SQL Server 2012 except for the Compact Edition to higher tier SQL Server editions. For example, you can upgrade Express, Web, and Workgroup editions to Standard, Enterprise, or Data Center editions. You can upgrade the Standard Edition to only the Enterprise or Data Center editions.

Edition Upgrade Matrix

  • Evaluation edition can be upgraded to:
    • Web
    • Developer
    • Standard
    • Enterprise
  • Developer edition can be upgraded to:
    • Web
    • Standard
    • Enterprise
  • Standard edition can be upgraded to:
    • Enterprise
  • Web edition can be upgraded to:
    • Standard
    • Enterprise
  • Express edition can be upgraded to:
    • Web
    • Developer
    • Standard
    • Enterprise

According to above matrix you can find out that is it possible for the edition upgradation you are looking for. Based on this you can actually make decision on which edition you should go for. You should choose the edition so that in future you should be able to upgrade easily which any major problems.

Version Upgrade

When it comes to upgrade Sql server version then it can come with two flavors.

  1. Either you want to upgrade only version not the edition. E.g. you want to upgrade Sql server 2008 standard edition to Sql 2012 standard edition.
  2. Or you want to upgrade both e.g. you want to upgrade Sql server 2008 standard edition to Sql 2012 enterprise edition.

There are again set of upgrade which are possible. Below is the list of those:

Version Upgrade Matrix

Upgrade from

Supported upgrade path

SQL Server 2008 SP4 Enterprise

SQL Server 2017 (14.x) Enterprise 

SQL Server 2008 SP4 Developer

SQL Server 2017 (14.x) Developer

SQL Server 2008 SP4 Standard

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2008 SP4 Small Business

SQL Server 2017 (14.x) Standard

SQL Server 2008 SP4 Web

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web

SQL Server 2008 SP4 Workgroup

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2008 SP4 Express

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Express

SQL Server 2008 R2 SP3 Datacenter

SQL Server 2017 (14.x) Enterprise 

SQL Server 2008 R2 SP3 Enterprise

SQL Server 2017 (14.x) Enterprise 

SQL Server 2008 R2 SP3 Developer

SQL Server 2017 (14.x) Developer

SQL Server 2008 R2 SP3 Small Business

SQL Server 2017 (14.x) Standard

SQL Server 2008 R2 SP3 Standard

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2008 R2 SP3 Web

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web

SQL Server 2008 R2 SP3 Workgroup

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2008 R2 SP3 Express

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Express

SQL Server 2012 (11.x) SP2 Enterprise

SQL Server 2017 (14.x) Enterprise 

SQL Server 2012 (11.x) SP2 Developer

SQL Server 2017 (14.x) Developer 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Enterprise 

SQL Server 2012 (11.x) SP2 Standard

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2012 (11.x) SP1 Web

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web

SQL Server 2012 (11.x) SP2 Express

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Express 

SQL Server 2012 (11.x) SP2 Business Intelligence

SQL Server 2017 (14.x) Enterprise 

SQL Server 2012 (11.x) SP2 Evaluation

SQL Server 2017 (14.x) Evaluation 

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Developer

SQL Server 2014 (12.x) Enterprise

SQL Server 2017 (14.x) Enterprise 

SQL Server 2014 (12.x) Developer

SQL Server 2017 (14.x) Developer 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Enterprise 

SQL Server 2014 (12.x) Standard

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2014 (12.x) Web

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web

SQL Server 2014 (12.x) Express

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Express 

SQL Server 2017 (14.x) Developer

SQL Server 2014 (12.x) Business Intelligence

SQL Server 2017 (14.x) Enterprise 

SQL Server 2014 (12.x) Evaluation

SQL Server 2017 (14.x) Evaluation 

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Developer

SQL Server 2016 (13.x) Enterprise

SQL Server 2017 (14.x) Enterprise 

SQL Server 2016 (13.x) Developer

SQL Server 2017 (14.x) Developer 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Enterprise 

SQL Server 2016 (13.x) Standard

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard

SQL Server 2016 (13.x) Web

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web

SQL Server 2016 (13.x) Express

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Express 

SQL Server 2017 (14.x) Developer

SQL Server 2016 (13.x) Business Intelligence

SQL Server 2017 (14.x) Enterprise 

SQL Server 2016 (13.x) Evaluation

SQL Server 2017 (14.x) Evaluation 

SQL Server 2017 (14.x) Enterprise 

SQL Server 2017 (14.x) Standard 

SQL Server 2017 (14.x) Web 

SQL Server 2017 (14.x) Developer

SQL Server 2017 (14.x) release candidate*

SQL Server 2017 (14.x) Enterprise

SQL Server 2017 (14.x) Developer

SQL Server 2017 (14.x) Enterprise

 

So one can make decisions of which edition\version it should buy so that it could be upgraded easily to new version\edition.

Deepak Gera

Hi, I am Deepak Gera, Consultant, Founder and Chief Editor for www.lazyheap.com. Working as Technical Architect and having diversification in Industry types, Tools, Techs.

Leave a Reply

Your email address will not be published. Required fields are marked *

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