Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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.

196 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 →

37 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

    Please add this feature ASAP, we need this for our existing scenario to restore prod copy after nightly load to use it for read copy for thousands of powerbi reports and downstream applications. Current backup restore taking 4 hrs to finish. Which is very painful to explain clients about synapse limitations.

  • Andy Steinke commented  ·   ·  Flag as inappropriate

    We have dev, stage, and prod subscriptions and having to perform these extra steps just adds delay, failure points, and frustration. Many companies of reasonable size will have multiple data warehouse environments and it should be almost as easy to restore prod to stage or dev as it is in good old fashioned SQL....

  • Lyn commented  ·   ·  Flag as inappropriate

    I need to restore/move databases from one managed instance in one subscription to another managed instance in another subscription - this functionality would make it so much easier

  • 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

← Previous 1

Azure Synapse Analytics: SQL/Management

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice