Forum Discussion
SQL SERVER Upgrade
How do i upgrade from SQL Server 2014 Enterprise Edition to 2017 Enterprise edition. Also what is the cost involved ?
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.
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
- 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
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.
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
