how to migrate from azure dedicated SQL pool to another azure dedicated SQL pool (different server,subscription)

Prasanna, Prashanth (RIS-CON) 20 Reputation points

I have around 3 TB of azureSQL DW . I want to migrate the entire DW to another azure DW which is under different subscription. what are the tools that can be used to achieve this or can you help me with the steps for the migration ? looks like I cannot use Export and Import BackPac since it is limited to 200 GB.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,145 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vinodh247 2,931 Reputation points


    Thanks for reaching out to Microsoft Q&A.

    Yes cross subscription restore is now possible. You have to use powershell for this, check the below article for step by step instructions on how to perform this.

    Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

0 additional answers

Sort by: Most helpful