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.

32 comments
-
Vipin commented
yes, we need it to refresh our lower servers from prod....
-
Anonymous commented
This will really help in situations when we want to test production data fixes before running them on production data.
-
Mark Maddox commented
Please add this feature.
-
Sandeep Arora commented
This is critical feature for a successful DevOps CI/CD as Team consistently come across scenarios with Data that's only available in elevated environments.
Moreover, Data Masking Built in would be icing on the cake.
-
Anonymous commented
This is very much needed for DR scenario, please add this feature as soon as possible.
-
Bill Sharon commented
This is a high value feature. Please add!
-
Ashish Tripathi commented
Please add this feature.
-
Satya commented
Please add this feature.
-
Cankurtaran, Tulu commented
much easier - please add this feature.
-
Bill Dillingham commented
Please add this feature
-
Alex Bennett commented
please add this feature!
-
Ahmed Mostafa commented
please implement this !!
-
Anonymous commented
Example of how this feature would help - For our larger clients, they opt to separate environments into their own subscriptions. When using source control and following a CICD process across a dev, test, prod environment, it makes life hard when trying to refresh the test environment with more recent data for UAT.
-
Anonymous commented
I have the need to copy the contents of an existing Synapse instance to a new instance in another subscription. This feature would enable a straightforward way of achieving this
-
Sam Zhao commented
receiving more customer requests. hope this feature can come soon.
-
Anonymous commented
Would be greatly appreciated!
-
Akhilesh Mittal commented
We are building product on Azure Synapse, would like to move the backup (DDL and data) from one subscription to another.
-
CARL WERNER commented
This will assist for a long term solution and a DR Plan as Sandeep has mentioned. This needs to be available for all Synapse Analytics Resources (SQL Pool/Server/Database). Moving a resource between subscriptions without a native backup needs to be addressed.
-
Dat commented
we would like to make our life easier, please give the capability of
CREATE DATABASE newDB AS COPY OF [sourceServer].[sourceDb], even with cross subscription/resource
or whatever easier for azure synapse analytics DW.
Please! Please! -
Anonymous commented
would be good to have option to replicate tables from one dwh to another across subscriptions.
Bruce.