Want to migrate from one Synapse workspace to another Synapse workspace

Question

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

Answer 1

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.

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 or upvote 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

Answer 2

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.