migration from SQL Server 12 to Sql Server 19

Question

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 

Answer 1

There is nothing like this. You can run SQL syntax in every SQL server edition..

Answer 2

You can try SQL Server Migration Assistant:  https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant