AZURE Data Factory – Copy with Stored Procedure Data from One Database to Another on AZURE SQL

This article outlines how to copy the tables from one Azure Database to another Azure Database using AZURE DATA FACTORY. Along with this, there is an example of how to work with FOR-Each and customized Stored Procedure to retrieve only the data that is required in the destination table. You can apply the same pattern in other copy scenario as well, for example, copying data from SQL to BLOB, SQL to CSV, SQL Server / Oracle to Azure SQL.