To be able to generate a dacpac and deploy it to a serverless SQL pool I would like to use the .NET project SDK.
https://github.com/microsoft/DacFx
I'm able to create a new project using the cli.
dotnet new sqlproj -n ProductsTutorial
I can also build it and deploy it.
However, our current database solution has multiple databases that reference each other. for example:
CREATE VIEW
AS
SELECT *
FROM [$(database_1)].[schema].[view]
How to create multiple databases inside a single project using the dotnet sdk and make them able to reference each other? Right now my dotnet build is failing because of unreferenced object errors.
Building and deploying a dacpac to a serverless pool on Synapse analytics is not supported using traditional SSDT/visual Studio 2022. Dacpac creation for serverless has just been released with the latest SQL package update
