SQL SERVER Upgrade

%3CLINGO-SUB%20id%3D%22lingo-sub-472664%22%20slang%3D%22en-US%22%3ESQL%20SERVER%20Upgrade%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472664%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20i%20upgrade%20from%20SQL%20Server%202014%20Enterprise%20Edition%20to%202017%20Enterprise%20edition.%20Also%20what%20is%20the%20cost%20involved%20%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FSQL-Upgrade%2Fm-p%2F223594%23U223594%22%20target%3D%22_blank%22%3ESQL%20Upgrade%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482732%22%20slang%3D%22en-US%22%3ERE%3A%20SQL%20SERVER%20Upgrade%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482732%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20orsondcunha%20%2C%3C%2FP%3E%3CP%3EYour%20question%20is%20not%20so%20clear.%20First%2C%20do%20you%20intent%20to%20plan%20a%20side%20by%20side%20upgrade%20or%20in%20place%20upgrade%20%3F%3C%2FP%3E%3CP%3E1.%20In%20place%20%3A%3C%2FP%3E%3CP%3EYou%20will%20keep%20the%20same%20server%2C%20your%20SQL%20instance%20will%20be%20Under%20downtime%20during%20the%20migration.%20No%20rollback%20plan%20is%20possible%2C%20except%20uninstalling%20%26amp%3B%20reinstalling%20all.%20The%20edition%20must%20be%20the%20same%20than%20the%20initial%20one%20(ie%20Enterprise)%3C%2FP%3E%3CP%3E2.%20Side%20by%20side%3C%2FP%3E%3CP%3EYou%20will%20install%20your%20SQL%20instance%20on%20a%20different%20server.%20You%20can%20reduce%20the%20downtime.%20It's%20not%20mandatory%20to%20deploy%20an%20Enterprise%20Edition%2C%20and%20regarding%20your%20needs%2C%20the%20standard%20edition%20may%20be%20enough%20since%20SQL%202016%20SP1%20(ref%20the%20link%20you%20mentioned).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20cost%20perspective%2C%20please%20have%20a%20look%20on%20the%20Licencing%20Guide%20%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fsql-server%2Fsql-server-2017-pricing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fsql-server%2Fsql-server-2017-pricing%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3EFred.M.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-505309%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20SQL%20SERVER%20Upgrade%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-505309%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20the%20quick%20response%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F149733%22%20target%3D%22_blank%22%3E%40frederic%20MICHALAK%3C%2FA%3E.%20Based%20on%20the%20options%20you%20gave%20me%2C%20we%20would%20like%20to%20go%20with%20option%201%20i.e%20an%20'in%20place%20upgrade'.%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20would%20be%20an%20approximate%20cost%20of%20upgrading%20to%202017%20enterprise%20edition%20from%202014%20enterprise%20edition%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EOrson%20DCunha%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-506991%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20SQL%20SERVER%20Upgrade%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506991%22%20slang%3D%22en-US%22%3EHey%20orsondcunha%3CBR%20%2F%3E%3CBR%20%2F%3Emy%20name%20is%20jay%20rindani.%20i%20would%20like%20to%20give%20small%20suggestion.%3CBR%20%2F%3E%3CBR%20%2F%3ESQL%20Server%202017%20editions%20Cost%3CBR%20%2F%3E%3CBR%20%2F%3EEnterprise%20(license)%20%2414%2C256%3CBR%20%2F%3EDeveloper%20FREE%3CBR%20%2F%3EExpress%20FREE%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIF%20you%20want%20to%20buy%20license%20version%20enterprise%20it%20will%20be%20costly%20so%2C%20i%20suggest%20you%20that%20download%20express%20version%20or%20developer%20version%3CBR%20%2F%3E%3CBR%20%2F%3Eplease%20check%20below%20link%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-in%2Fsql-server%2Fsql-server-2017-pricing%23ft2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-in%2Fsql-server%2Fsql-server-2017-pricing%23ft2%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540186%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20SQL%20SERVER%20Upgrade%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F331023%22%20target%3D%22_blank%22%3E%40JRINDANI%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDevelopper%20Edition%20is%20%3CSTRONG%3Ereserved%20only%20for%20Non-Production%20Environment%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3ERef.%20attachment%20page%205.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-651712%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20SERVER%20Upgrade%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F323528%22%20target%3D%22_blank%22%3E%40orsondcunha%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EBefore%20Upgrade%20SQL%20server%202014%20to%202017.%20I%20would%20recommend%20to%20first%26nbsp%3B%20download%20%E2%80%9CMicrosoft%20Data%20Migration%20Assistant%E2%80%9D%20tool.%20This%20tool%20will%20identities%20all%20the%20issues%20before%20upgrade%20from%20SQL%202014%20to%20SQL%202017.%20You%20need%20to%20fix%20all%20issues%20before%20upgrade%20from%20SQL%202014%20to%202017.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D53595%26amp%3B751be11f-ede8-5a0c-058c-2ee190a24fa6%3DTrue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D53595%26amp%3B751be11f-ede8-5a0c-058c-2ee190a24fa6%3DTrue%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20recommend%20Side%20by%20Side%20migration%20approach.%20Please%20create%20checklist%20before%20upgrade%20server.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3ESr.No%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EChecklist%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ESQL%202014%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ESQL%202017%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EBackup%20all%20database%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Logins%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Audit%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20linked%20server%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20Triggers%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Policies%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E7%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Data%20Collection%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E8%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Maintenance%20Plan%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E9%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Database%20Mail%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E10%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%26nbsp%3B%20SQL%20Jobs%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E11%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Alert%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E12%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Operators%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E13%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20Proxies%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E14%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ECopy%20all%20System%20Database%20Procedures%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E15%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EUpgrading%20Data%20Transformation%20Services%20(DTS)%20and%20Integration%20Services%20(SSIS)%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E16%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ERestore%20all%20Database%20to%20New%20server%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

SQL Upgrade 

5 Replies
Highlighted

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.

Highlighted

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

Highlighted
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
Highlighted

@JRINDANI 

Developper Edition is reserved only for Non-Production Environment.

Ref. attachment page 5.

 

Highlighted

@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