azureazure-sql-databaseazure-synapseazure-synapse-analyticsazure-synapse-pipeline

Azure Synapse - Move SQLPool to another workspace

I need to redeploy my synapse workspace, but want to keep all dedicated sqlPools.

How can the sqlPools getting moved to a different synapse workspace like this:

enter image description here

Solution

  • Using Restore point can be one of the ways to achieve your requirement. But in this method, you need to create new pool in another synapse workspace and delete or pass the old one in old workspace.

    This is my sample table in the dedicated pool of old synapse workspace.

    enter image description here

    First Go to your Dedicated SQL pool and create a restore point for it.

    enter image description here

    We need to use this restore point while creating new dedicated pool in the target synapse workspace.

    First Give your new dedicated pool name and in Additional settings use the restore point and create it.

    enter image description here

    You can see we got the data from that pool here(I have not inserted any data in it).

    enter image description here

    But, if you want to move lot of pools, this method involves lot of manual work.