Dacpac
A DACPAC is a SQL Server data-tier application package containing definitions of database objects for schema deployment.
Learn Docker in a Month of Lunches, Second Edition
A DACPAC is a binary data-tier application package that contains the schema definition of a SQL Server database.
- How it is used
- Deploys versioned SQL Server schema changes consistently across disposable environments and production.
- How deep it goes
- Defines the artifact and deployment workflow, but deliberately avoids deeper SQL Server-specific implementation details.
- Examples
- Uses the Nerd Dinner database image, Dockerfile, initialization script, and container startup deployment.
- What you can do after
- Build and deploy a versioned SQL Server schema through a DACPAC and Docker image.
Read how Learn Docker in a Month of Lunches, Second Edition explains dacpac →
100 SQL Server Mistakes and How to Avoid Them
A dacpac file is a SQL Server database deployment package containing XML definitions of database objects.
- How it is used
- Packages database project output for tested, source-controlled deployment through CI/CD environments.
- How deep it goes
- Defines the zip and XML structure and places creation within build services, but does not detail deployment internals.
- Examples
- Uses Visual Studio publishing, the Register As a Data-tier Application option, and renaming a dacpac to .zip for inspection.
- What you can do after
- Apply it via CI/CD tooling to package and promote database changes across release environments.
Read how 100 SQL Server Mistakes and How to Avoid Them explains dacpac →
Related concepts
- deployment artifactkind of · A deployment artifact is a software output, such as a file, package, or image, prepared for distribution, installation, execution, or deployment.
- SQL scriptproduced by · An SQL script is a file or command sequence containing SQL statements for defining, querying, initializing, or modifying database structures and data.
- build serviceproduced by · A build service is an automated service that compiles or packages software and executes associated validation steps.
- SQL Serveruses · SQL Server is Microsoft's relational database management system for storing, querying, transforming, and managing structured data.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.