How can I use Azure data factory to migrate stored procedures between 2 SQL servers?

0
votes

I need to write ADF pipelines to completely migrate all tables and stored procedures from one Azure SQL db to another. I got a pipeline with foreach and copy activities to copy all tables, and want to do the same to migrate all stored procedures to new database. How can I copy the stored procedures?

Any assistance is appreciated. Thank you.

1
azureazure-sql-databaseazure-data-factoryazure-data-factory-2azure-data-factory-pipeline

1 Answers

1
votes

ADF is not the right tool for this task. Use the Visual Studio Schema Compare and Data Compare features instead.