SQL SERVER Upgrade

[orsondcunha]

How do i upgrade from SQL Server 2014 Enterprise Edition to 2017 Enterprise edition. Also what is the cost involved ?

SQL Upgrade 

[#2]

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.

[#3]

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

[#4]

Hey orsondcunha

my name is jay rindani. i would like to give small suggestion.

SQL Server 2017 editions Cost

Enterprise (license) $14,256
Developer FREE
Express FREE


IF you want to buy license version enterprise it will be costly so, i suggest you that download express version or developer version

please check below link
https://www.microsoft.com/en-in/sql-server/sql-server-2017-pricing#ft2

[#5]

@JRINDANI 

Developper Edition is reserved only for Non-Production Environment.

Ref. attachment page 5.

[#6]

@orsondcunha  

Before Upgrade SQL server 2014 to 2017. I would recommend to first  download “Microsoft Data Migration Assistant” tool. This tool will identities all the issues before upgrade from SQL 2014 to SQL 2017. You need to fix all issues before upgrade from SQL 2014 to 2017.

https://www.microsoft.com/en-us/download/details.aspx?id=53595&751be11f-ede8-5a0c-058c-2ee190a24fa6=...

I would recommend Side by Side migration approach. Please create checklist before upgrade server.

Sr.No	Checklist	SQL 2014	SQL 2017
1	Backup all database
2	Copy all Logins
3	Copy all Audit
4	Copy all linked server
5	Copy Triggers
6	Copy all Policies
7	Copy all Data Collection
8	Copy all Maintenance Plan
9	Copy all Database Mail
10	Copy all  SQL Jobs
11	Copy all Alert
12	Copy all Operators
13	Copy all Proxies
14	Copy all System Database Procedures
15	Upgrading Data Transformation Services (DTS) and Integration Services (SSIS)
16	Restore all Database to New server