Is SSDT available for SQL Serverless Pool Databases in Synapse Analytics?

Question

Can SSDT projects in Visual Studio be used to deploy database projects to a SQL Serverless Pool Database in Synapse Analytics?

Currently I used SSDT projects to manage changes to a Azure SQL Database, and I am looking to switch to Synapse Analytics but it seems I am unable to use SSDT projects to manage SQL Serverless Pool Databases in Synapse Analytics. I have even tried switching 'Target Platform' to Azure SQL Data Warehouse in the database properties but this has not worked so far.

Answer 1

Hello @Neal Amin ,

Welcome to the Microsoft Q&A platform.

Serverless SQL pool is not supported by SSDT.

For more details, refer to Connect to Synapse SQL with Visual Studio and SSDT.

I would suggest you to vote up an idea submitted by another Azure customer.

https://feedback.azure.com/forums/307516-azure-synapse-analytics/suggestions/43390092-support-for-ssdt-in-synapse-serverless-sql

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

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

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

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.