MSBuild.Sdk.SqlProj is an SDK-style .NET project format for managing SQL Server schemas as code and building .dacpac files. Version 4.0.0 introduces container image publishing via `dotnet publish /t:PublishContainer`, which bundles SqlPackage and the .dacpac into a self-contained Docker image. This enables reproducible, tool-free database deployments across any environment with a container runtime. The post covers the SDK's general advantages (cross-platform, NuGet references, DacFX code analysis, .NET Aspire integration) and walks through the full container publishing workflow including CI/CD pipeline integration with GitHub Actions, Azure Pipelines, and others.

6m read timeFrom erikej.github.io
Post cover image
Table of contents
What is MSBuild.Sdk.SqlProj?General Advantages of MSBuild.Sdk.SqlProjPublishing as a Container ImageGetting Started

Sort: