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

Rahul 251 Reputation points
2024-04-24T13:06:18.93+00:00

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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,717 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sedat SALMAN 13,180 Reputation points
    2024-04-24T15:17:22.65+00:00

    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