I have been tasked with devising a plan for an upgrade of MSSQL 2005 to MSSQL 2016. Doesn't look without is challenges, least of all ensuring that all code will still work with all the deprecated features between 2005 and 2016.
Apologies if this is a noob question, as my background is in dev, as opposed to administration so I don't have any experience in upgrades, but I wondered if there were any tools available to to check if code is compatible with a specific version, or if it points out which versions it will not be compatible with?
As you can imagine, we have reams of stored procs, so just looking for the easiest way to check that these function, and wanted to check of there was another way, other than upgrading on a test box and setting them off to see.
Appreciate any assistance.