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.
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.
Yes, it'd make our life easier to restore Dev/Test environment for developers.
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.
Definitely need this to move Production down to Development.
This would make the restore simple and will save time.
this helps with lower environment refreshes
Pls guys, this will help us with refreshing out dev environment