Enable support for cross subscription restore
The current workaround for cross subscription restore is:
- Restore to a new logical server in the same prod subscription
- ‘Move’ the new logical server with the restored data warehouse to new subscription
It would be faster and simpler to enable restore directly to a different subscription.
AdminAzure Synapse Team
(Admin, Microsoft Azure)
shared this idea
11 comments
-
Karthick Murugan
commented
We want a script to do restore synapse data warehouses across subscriptions not databases.( As there is a difference in supported features between those.)
Preferable to an existing SQL Server in target subscription. -
Jamadagni, Naresh N [INNJBI]
commented
Please add this feature, it will help us refresh environments across subscription.
-
Anonymous
commented
This would be excellent for migration between Azure tenants
-
Brian Brooks
commented
With separate prod/non-prod subscriptions, we need this capability to simplify non-prod database refreshes.
-
John McCormack
commented
I recommend this functionality is given serious consideration.
-
Anonymous
commented
Yes, it'd make our life easier to restore Dev/Test environment for developers.
-
Anonymous
commented
Please view this feature as a necessity, as restoring production to lower regions efficiently is necessary in order to properly support a Data Warehouse. Missing features such as this make us hesitant to recommend the use of Azure SQL DW.
-
Anonymous
commented
Definitely need this to move Production down to Development.
-
Anonymous
commented
This would make the restore simple and will save time.
-
Anonymous
commented
this helps with lower environment refreshes
-
Anonymous
commented
Pls guys, this will help us with refreshing out dev environment