0

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

R. Maier
  • 340
  • 2
  • 13

1 Answers1

0

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.

Rakesh Govindula
  • 5,257
  • 1
  • 2
  • 11