04-18-2019 10:43 AM
04-25-2019 07:31 AM - edited 04-25-2019 07:32 AM
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.
04-30-2019 10:59 AM - edited 04-30-2019 11:01 AM
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?
04-30-2019 11:28 PM
05-28-2019 04:03 AM
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.
Backup all database
Copy all Logins
Copy all Audit
Copy all linked server
Copy all Policies
Copy all Data Collection
Copy all Maintenance Plan
Copy all Database Mail
Copy all SQL Jobs
Copy all Alert
Copy all Operators
Copy all Proxies
Copy all System Database Procedures
Upgrading Data Transformation Services (DTS) and Integration Services (SSIS)
Restore all Database to New server
by vetrivel2020 on April 23, 2020
by Jaywork on March 18, 2020
by NathanMSFT on May 29, 2020
by Adrian_Rupp on May 29, 2020
by JAYNAR on December 19, 2019