Forum Discussion

orsondcunha's avatar
orsondcunha
Copper Contributor
Apr 18, 2019

SQL SERVER Upgrade

How do i upgrade from SQL Server 2014 Enterprise Edition to 2017 Enterprise edition. Also what is the cost involved ? SQL Upgrade 
frederic MICHALAK's avatar
frederic MICHALAK
Copper Contributor

Hi orsondcunha ,

Your question is not so clear. First, do you intent to plan a side by side upgrade or in place upgrade ?

1. In place :

You will keep the same server, your SQL instance will be Under downtime during the migration. No rollback plan is possible, except uninstalling & reinstalling all. The edition must be the same than the initial one (ie Enterprise)

2. Side by side

You will install your SQL instance on a different server. You can reduce the downtime. It's not mandatory to deploy an Enterprise Edition, and regarding your needs, the standard edition may be enough since SQL 2016 SP1 (ref the link you mentioned).

 

For cost perspective, please have a look on the Licencing Guide : https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing

 

Hope this helps.

Fred.M.

orsondcunha's avatar
orsondcunha
Copper Contributor
Apr 30, 2019

Thank you for the quick response frederic MICHALAK. Based on the options you gave me, we would like to go with option 1 i.e an 'in place upgrade'. 

What would be an approximate cost of upgrading to 2017 enterprise edition from 2014 enterprise edition?

 

Regards,

Orson DCunha

Resources