What problems should be considered when migrating from MS SQL Server 2012 to MS SQL Server 2014?

Question

SQL Server

Good day.
Our project is planning to switch from MS SQL Server 2012 to MS SQL Server 2014.
As a QA engineer, I would like to know what potential problems may arise and what bottlenecks should I pay attention to?
Thanks in advance.

Answer 1

No one will tell you what problems you may have, at most a couple of typical problems that are googled in 5 minutes. The most correct thing is to take the installation of the 2014 version, restore the backup of the combat database there, set the test environment there and try to work with it. 95% of the problems will surface in the very first hours.

Answer 2

I recently transferred a full backup using the usual Restore method ... Everything went ok and so far I haven’t revealed 1 error :)
So, I’ll answer with almost certainty - no. But you never know ... I don’t know all the factors)

Answer 3

Translated from 2008 to 2014, no problems were fixed. All databases are self-written, but there were also MS ones. Naturally, before that there was a test environment with a week of work from programmers)

Answer 4

Here https://docs.microsoft.com/en-us/sql/t-sql/stateme...
section Differences Between Lower Compatibility Levels and Level 120.
And as usual, documentation on "breaking change", "deprecated features " and repair packages, lists of what was fixed.