Suggest an idea for a new or improved feature!

← Azure Synapse Analytics

Enable support for cross subscription restore

The current workaround for cross subscription restore is:


  1. Restore to a new logical server in the same prod subscription

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

172 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminAzure Synapse Team (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

32 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    This will really help in situations when we want to test production data fixes before running them on production data.

  • Sandeep Arora commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    This is very much needed for DR scenario, please add this feature as soon as possible.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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

  • Akhilesh Mittal commented  ·   ·  Flag as inappropriate

    We are building product on Azure Synapse, would like to move the backup (DDL and data) from one subscription to another.

  • CARL WERNER commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    would be good to have option to replicate tables from one dwh to another across subscriptions.
    Bruce.

← Previous 1

Azure Synapse Analytics: SQL/Management

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice