A DACPAC is a binary deployment artifact containing a SQL Server database schema. Build it from SQL scripts, then deploy it to create a database or upgrade an existing schema. section 13.4
A DACPAC supports two practical workflows:
- Deploy to an empty SQL Server instance to create a clean database. section 13.4
- Deploy to an existing database to upgrade its schema to the DACPAC definition. section 13.4
- Package the artifact in a Docker image for disposable development and test databases or production deployment. section 13.4
Containerized database deployment
A multi-stage Docker build compiles the database project with the .NET SDK, copies NerdDinner.dacpac into a SQL Server image, and runs a PowerShell initialization script when the container starts.

