3: Limitations

Currently, there are some limitations with deploying a dacpac to a serverless SQL Pool based on a database project, as below:

• You can only deploy a dacpac that has been created especially for serverless SQL Pools. Either a database project especially created for a serverless SQL pool or a dacpac based on an existing serverless SQL Pool.

• Serverless SQL Pools only support certain objects. You can read more about this in detail in the Microsoft page about Transact-SQL features supported in Azure Synapse SQL.

• Note that at this moment in time it appears that creating external File Formats using T-SQL are not supported for database projects for serverless SQL Pools. However, creating data sources is fine. So, you can still create views. Which is what I show in this example. However, you might want to consider extracting the contents of an existing serverless SQL Pool into a dacpac instead. Which I cover in a post about deploying a dacpac to a serverless SQL pool.