This question already has an answer here:
We are going the create our Sql-Servers new on new hardware / VM's and think about which Sql-Server Version to go with. We are actually using Sql Server 2008 R2. We have already done a project for testing everything for any compatibility issues between 2008 and 2014 - and have fixed all issues in application code as well as in the db schemas to be ready for 2014.
Now the question for simply dismissing 2014 and directly go to 2016 came up. We are not sure.
I have ran SQL 2016 Upgrade Advisor - it said "ready for upgrade (2016)" and raised around 500 warnings for deprecated ntext, text and image columns.
- Are there any special additional downsides of going to 2016 instead of 2014?
- Are there new compatibility issues? AFAIKS there have been no new deprecations in 2016 that are not yet in place of 2014...
- What do we have to consider?