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

Prasanna, Prashanth (RIS-CON) 20 Reputation points
2023-05-04T10:45:24.0866667+00:00

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.
9,933 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vinodh247-1375 12,421 Reputation points
    2023-05-04T11:23:33.0633333+00:00

    Hi

    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.

    https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/announcing-general-availability-of-cross-subscription-restore/ba-p/3280185

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw#restore-an-existing-dedicated-sql-pool-formerly-sql-dw-through-powershell

    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