upgrade sql 2014 to sql 2017 and skipping sql 2016?

Question

upgrade sql 2014 to sql 2017 and skipping sql 2016?

JP10

SSCarpal Tunnel

Points: 4372
More actions
January 8, 2019 at 12:37 pm

#409421

Hello,
When upgrading sql 2014 to 2017 can we skip upgrading sql 2014 to 2016 and just upgrading from sql 2014 to sql2017? Or do we have to upgrade to sql 2016 first then upgrade again from 2016 to 2017?
Appreciate the help.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

JP10 - Tuesday, January 8, 2019 12:37 PM
Hello,
When upgrading sql 2014 to 2017 can we skip upgrading sql 2014 to 2016 and just upgrading from sql 2014 to sql2017? Or do we have to upgrade to sql 2016 first then upgrade again from 2016 to 2017?
Appreciate the help.

Of course. Check this document for full details of supported upgrade paths.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Michael L John One Orange Chip Points: 27055 More actions · Answer 2

Are you performing an in-place upgrade? Or are you moving databases from an old to a new server?

If you are performing an in-place upgrade, it can be done but I probably would not do it. For no other reason, there is no turning back if something fails. I would suggest bringing up a new server with 2017 installed, and migrate the databases.
If you are moving databases from 2014 to 2017, then that's no problem.
You should set the compatibility level once migrated, run DBCC CHECKDB, and update all stats once completed.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

If you are performing an in-place upgrade, it can be done but I probably would not do it. For no other reason, there is no turning back if something fails.

Unless it's a VM, in which case taking a snapshot and rolling back is perfectly feasible.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

JP10 SSCarpal Tunnel Points: 4372 More actions · Answer 4

Thanks for the link to upgrade path Phil. @michael-2 yes it would be an in place upgrade. Makes life easier if I can just skip the sql 2016 install. Just wanted to make sure. But, yes my push is to go down the side by side upgrade method. I'm just in the planning stages right now. Appreciate the help guys!

Johnson Welch SSCoach Points: 18773 More actions · Answer 5

Check out:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup?view=sql-server-2017

Tom Uellner SSCrazy Points: 2995 More actions · Answer 6

Installing on a new VM allows you to take advantage of installing a newer OS version as well. Just one more thing to consider.
Not so bad if you're current box is on Windows Server 2012 R2 but if it's on 2008 / 2008 R2 then how much longer is the OS going to be in mainstream support (if that matters to you).