How can I do Data movement from MSSQL server to MSSQL server?
Hi @dhriti.chowdhury1606755655995,
If you are doing SQL to SQL then I would suggest using the tried and true SQL Server Integrations Services (SSIS). In my opinion it's hands down the most robust, complete, and solid ETL/ELT/integration tool out there. Granted, Microsoft had about 3 decades to make it what it is today.
Of the top of my head I can think of one possible way of doing this in Matillion but it would be extremely slow and more complicated than need be compared to SSIS. In my mind it's all about picking the right tool for the job and for this data movement it seems like SSIS would be it.
I hope this helps.
You could try the new "Reverse ETL" features which were introduced to Matillion in version 1.51. Please refer to the Microsoft SQL Server Output documentation.