Azure Data Warehouse Migration

Question

Azure Data Warehouse Migration

AXS 1

Hi,

I have one azure subscription where I have a data warehouse with data tables that I stored uploaded data. I want to migrate those data tables to my new azure subscription account.

Note: I cannot delete the old account.

What is the best way to migrate the data warehouse?

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2022-07-21T15:38:08.677+00:00

Hey,
Do you want to move the SQL dedicated pool or just clone the tables in another Dedicated pool?
AXS 1 Reputation point

2022-07-21T16:13:55.257+00:00

so its more of download the old database and import to new subscription account.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-07-22T20:46:57.273+00:00
@Nandan Hegde , thank you!

Hello @AXS ,
I am checking in to see if the below answer from @Nandan Hegde helped. And if you have any further queries, do let us know.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

1 answer

Your answer

Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2022-07-21T15:38:08.677+00:00

Hey,
Do you want to move the SQL dedicated pool or just clone the tables in another Dedicated pool?
AXS 1 Reputation point

2022-07-21T16:13:55.257+00:00

so its more of download the old database and import to new subscription account.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-07-22T20:46:57.273+00:00

@Nandan Hegde , thank you!

Hello @AXS ,
I am checking in to see if the below answer from @Nandan Hegde helped. And if you have any further queries, do let us know.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 1

Nandan Hegde 36,151 MVP Volunteer Moderator

Hey,
Assuming you have a single account across both the subscriptions, please follow the below blog:
https://faun.pub/migrate-your-azure-synapse-analytics-sql-dw-to-another-tenant-f6fd4cd0e926

Share via

Azure Data Warehouse Migration

1 answer

Your answer