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.
AdminSQL DW Team
(Feedback, Microsoft Azure)
shared this idea
8 comments
-
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