Azure Synapse Analytics Workspace And its Dedicated SQL Pool Migration From one subscription to another subscription during Cross Subscription Migration

Question

Azure Synapse Analytics Workspace And its Dedicated SQL Pool Migration From one subscription to another subscription during Cross Subscription Migration

Maaz Ahmed Nagori 0

I just Want to know that how can I migrate synapse workspace and its dedicated SQL pool from one subscription to another subscription during cross subscription migration

Smaran Thoomu 24,575 Reputation points Microsoft External Staff Moderator

2024-05-07T12:04:46.2+00:00

@Maaz Ahmed Nagori Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Your answer

Smaran Thoomu 24,575 Reputation points Microsoft External Staff Moderator

2024-05-07T12:04:46.2+00:00

@Maaz Ahmed Nagori Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Smaran Thoomu 24,575 Microsoft External Staff Moderator

Hi @Maaz Ahmed Nagori

Thank you for reaching out to the community forum with your query.

UPDATED Answer: You can leverage this feature whether you want to restore a standalone dedicated SQL pool (formerly SQL DW) or a dedicated SQL pool in a synapse workspace. You can refer to the following documentation for end-to-end examples of cross-subscription restore for dedicated SQL pools:

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

Unfortunately, you cannot transfer subscription from one Azure Synapse Analytics workspace to another.

User's image

Reference doc: https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/move-support-resources#microsoftsynapse

I would suggest you to vote up an idea submitted by another Azure customer.

Transfer an entire Azure Synapse Analytics workspace to another subscription

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Maaz Ahmed Nagori 0 Reputation points

2024-05-02T14:39:47.72+00:00

Thanks For sharing the information but I already know that move is not supported by Synapse workspace but according to the Microsoft documentation, we move it into a different subscription by making a restore point and by using the PowerShell script. But the main problem is that the script is giving an error Restore-AzSqlDatabase: Long running operation failed with status 'Failed'. Additional Info:'For point-in-time restores, the target logical server must be the same as the source logical server. Consider restoring to the source database's server, or using database copy or database recovery.'

I have also attached the documentation link 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
Maaz Ahmed Nagori 0 Reputation points

2024-05-02T14:43:13.1433333+00:00

you can refer to the document that I have shared
Smaran Thoomu 24,575 Reputation points Microsoft External Staff Moderator

2024-05-03T07:42:52.1266667+00:00

I apologize for the confusion caused by my previous response. You can leverage this feature whether you want to restore a standalone dedicated SQL pool (formerly SQL DW) or a dedicated SQL pool in a synapse workspace. You can refer to the following documentation for end-to-end examples of cross-subscription restore for dedicated SQL pools:

https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/announcing-general-availability-of-cross-subscription-restore/ba-p/3280185
Maaz Ahmed Nagori 0 Reputation points

2024-05-06T14:27:05.0366667+00:00

After following the documentation the synapse workspace and its dedicated SQL pools are cloned in my destination subscription but the data is not cloned in the destination subscription.
Smaran Thoomu 24,575 Reputation points Microsoft External Staff Moderator

2024-05-06T16:28:12.87+00:00

Maaz Ahmed Nagori Apologies for that here is the correct link - https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/announcing-general-availability-of-cross-subscription-restore/ba-p/3280185

Share via

Azure Synapse Analytics Workspace And its Dedicated SQL Pool Migration From one subscription to another subscription during Cross Subscription Migration

1 answer

Your answer