question

NealAmin-4555 avatar image
0 Votes"
NealAmin-4555 asked PRADEEPCHEEKATLA-MSFT commented

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

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.

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
1 Vote"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @NealAmin-4555,

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you Pradeep

0 Votes 0 ·

Hello @NealAmin-4555,

Glad to know it helped.

0 Votes 0 ·