Forum Discussion
smedikonda
Oct 16, 2023Copper Contributor
Looking for tool to validate MS SQL databases before upgrade (SQL 2014) and after upgrade (SQL 2022)
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 ob...
olafhelper
Oct 17, 2023Bronze Contributor
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
- smedikondaOct 18, 2023Copper Contributorolafhelper ... 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.
- olafhelperOct 19, 2023Bronze Contributor
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.