Looking for tool to validate MS SQL databases before upgrade (SQL 2014) and after upgrade (SQL 2022)

[smedikonda]

Please advise. We are planning to migrate our OLTP database from SQL 2014 to SQL 2022. We are looking for a tool that can be run against our 2014 database to analyze and identify any deprecated or obsolete programmability SQL code constructs. We expect the tool to give a report that can help in refactoring to SQL 2022-supported SQL constructs. 

[#2]

@smedikonda for this you can use the free Microsoft tool DMA = "Data Migration Assistant", see

Overview of Data Migration Assistant (SQL Server) - SQL Server | Microsoft Learn

Download Data Migration Assistant from Official Microsoft Download Center

[#3]

@olafhelper ... Thank you for the reply. We checked that tool, Data Migration Assistant the generated report not helping to analyze the existing SQL 2014 Database regarding the Stored procedures, functions, and Queries to find the deprecated or obsolete code constructs.

[#4]

---

@smedikonda wrote:
@olafhelper... Thank you for the reply. We checked that tool, Data Migration Assistant the generated report not helping to analyze the existing SQL 2014 Database regarding the Stored procedures, functions, and Queries to find the deprecated or obsolete code constructs.

---

@smedikonda , it do.