Loading

migration from SQL Server 12 to Sql Server 19

Nikhil Deshpande

Hello,

Is there a specific documention for using Data Migration Assistant (DMA) tool ?

We used DMA tool and found errors for SQL Joins .(old style join syntax) ... is there a tool where you can copy/paste old SQL or stored procedures and it will convert to the cureent SQL 2019 version compatible.

Thanks for all the help and support

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand2y ago
You can try SQL Server Migration Assistant: https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant
+1
Satyaprakash Samantaray2y ago
There is nothing like this. You can run SQL syntax in every SQL server edition..
+1