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.
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