existing SQL Pool to the new Synapse workspace.

Question

Hey All,

I want to use the existing SQL Pool to the new Synapse workspace.
As per the document attached, it's possible to do using Azure Portal
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/workspace-connected-create#enabling-synapse-workspace-features-for-an-existing-dedicated-sql-pool-formerly-sql-dw

Is there a way CLI or PowerShell commands for that?

Regards,
Jaydeep

Answer 1

Hello @Jaydeep Bhola ,

Welcome to the Microsoft Q&A platform.

Unfortunately, there is no CLI or PowerShell commands to enabling Synapse workspace features for an existing dedicated SQL pool.

Reference: Enabling Synapse workspace features for an existing dedicated SQL pool (formerly SQL DW)

Hope this helps. Do let us know if you any further queries.

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

• Please accept an answer if correct. 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.

Answer 2

Below PowerShell command might help

Restore-AzSynapseSqlPool

https://learn.microsoft.com/en-us/powershell/module/az.synapse/restore-azsynapsesqlpool?view=azps-5.4.0

Please see all PS commands for Azure synapse

https://learn.microsoft.com/en-us/powershell/module/az.synapse/?view=azps-5.4.0

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav