How to copy one database from one subscription to the another subscription in Azure

Question

Usecase- I want to copy one database from one subscription to the another subscription in the Azure data factory.

I want to make sure that all the tables, primary key, foreign key , constraints , not-null and all the attributes of the table and data gets migrated/copied properly.

Please help in the detailed steps to perform above.

Condition- I cannot connect the azure sql database through the SSMS , as public network connection is not possible.

Answer 1

you need to follow these steps

1. Set up an ADF new instance
2. Configure linked services for both the source and target Azure SQL Databases within Data Factory.
3. Create a pipeline using the “Copy Data” activity to specify what data is transferred and how it is mapped.
4. Validate, run the pipeline, and use the monitoring tools within Azure Data Factory to ensure successful data transfer.

In addition, you can go through those references

https://docs.microsoft.com/en-us/azure/data-factory/

https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview

and there is tutorial on how to copy data between Azure SQL Databases

https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-portal