Zack
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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/
https://www.mssqltips.com/sqlservertip/1857/identify-deprecated-sql-server-code-with-extended-events/
ASKER