Link to home
Start Free TrialLog in
Avatar of Zack
ZackFlag for Australia

asked on

Upgrading an old legacy SQL server 20082 to 2014 - TSQL compatibility

Heyas,

We have an old SQL server 2008 R2 that we want to upgrade to SQL 2014. The issue is that a lot of the applications on it are legacy (running in SQL 2000/2005 compatibility mode) and in some cases, the developers have gone out of business. My query is what are some tools we can use the test to see whether this SQL code will run in SQL 2014 other than the Upgrade Advisor.

Any assistance is welcome.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of OriNetworks
OriNetworks

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zack

ASKER

Thank you for your advice.
Avatar of Zack

ASKER

Additional info: A step for getting an insight into the high-risk code on your current SQL server instance:

https://www.mssqltips.com/sqlservertip/1857/identify-deprecated-sql-server-code-with-extended-events/