Want to migrate from one Synapse workspace to another Synapse workspace

Naga 71 Reputation points
2021-10-18T15:17:49.867+00:00

Hi team,

Want to migrate from one Synapse workspace to another Synapse workspace. One being Dev environment, another one test environment. Please provide leads.

Regards,
NagaSri

Azure Database Migration service
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,478 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,973 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,211 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,803 questions
0 comments
Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 90,146 Reputation points Microsoft Employee
    2021-10-19T04:00:37.143+00:00

    Hi @Naga ,

    Thanks for the question and using MS Q&A platform.

    Currently, you cannot migrate from one Synapse workspace to another Synapse workspace.

    Reason: Resource movement is not supported in Azure Synapse Analytics.

    141581-image.png

    For more details, refer Supported Resources - Microsoft.Synapse.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mehdi Belkhiria 0 Reputation points Microsoft Employee
    2024-07-12T15:07:38.5833333+00:00

    If you’re looking to migrate from one Synapse workspace to another (for example, from a Dev environment to a Test environment), here are a couple of strategies you might find helpful:

    Git Integration: One of the easiest ways to manage your Synapse artifacts (like notebooks, data flows, pipelines, etc.) is to integrate your workspace with Git. This allows you to version control your artifacts and use a CI/CD pipeline to deploy these artifacts from your Dev workspace to your Test workspace.

    Dedicated SQL Pool Restore: For the data in your dedicated SQL pool, you can create a backup of your database in the Dev environment and then restore it in the Test environment.

    Please note that currently, it’s not possible to move an entire Synapse workspace from one to another. But you can import the notebook, pipeline, and SQL code like the steps above.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.