Want to move Synapse workspace

Question

Hi everyone,

I need to redeploy my Azure Synapse workspace but want to ensure that all of my dedicated SQL Pools remain intact and unaffected by the redeployment process. What steps should I follow to safely redeploy the workspace while retaining the SQL Pools?

Any guidance would be greatly appreciated. Thanks!

Answer 1

To safely redeploy your Azure Synapse workspace without affecting your dedicated SQL pools, follow these steps:

Ensure you have backups of critical components (like SQL scripts, pipeline configurations, notebooks, etc.) and configurations from your current Synapse workspace.

Take snapshots of your dedicated SQL Pools if needed.

Yu can use ARM templates to capture the configuration of your Synapse workspace. You can export the ARM template of your existing Synapse workspace via the Azure Portal.

Navigate to your Synapse workspace > Automation script > Export the template.

Modify the template to exclude resources (like SQL pools) that should not be redeployed.

In the ARM template, identify the resources related to the dedicated SQL pools and ensure they are not included in the deployment steps. This way, the SQL pools remain unaffected by the redeployment.

Focus only on redeploying the Synapse components (pipelines, workspaces, ...).

Use the modified ARM template to redeploy your Synapse workspace and deploy the template either via Azure Portal, Azure CLI, or PowerShell.

Once the workspace is redeployed, verify that all your dedicated SQL pools remain intact and operational.

Check that your SQL pools, data, and existing configurations are not affected by the redeployment.