So it's time to upgrade out servers. I'm new in this company and we have SQL Servers from 2008 to 2014. I really don't see a problem upgrading all of them to 2014 because it's really wel documented and it's well known by the comunity. Its support ends in 7/9/2024 right? what are the reasons to upgrade directly to SQL Server 2016?
I could find A lot of websites comparing them but those are not features that we are using nowadays.
I would like to ugraprade directly to 2016 since its suport ends on 7/14/2026 but I'm afraid it has a lot of changes in queries since 2008/2012 (like deprecated features being removed ).
Is SQL Server upgrade advisor a trusty tool to use to make tests like this?
I've in the past upgrades our environment ( different company ) from SQL SERVER 2005/2008 to 2014 without problems.
and since we have quite few databases ( Like less then 10 in every server ), it's safer to backup/restore then into the new environment right? I don't feel confident doing in place upgrades.
And as far as i know, we can't migrate a database directly from SQL Server 2008 (100) to sql server 2016 right ?