A command-line utility for working with SQL databases. DACPACs are produced with Extract and deployed with Publish; BACPACs use Export and Import; and Script, DeployReport and DriftReport let you see changes beforehand.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SqlPackage in context, with comparison tables and the common traps.
Terms in this definition
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- ELT
Extract, load, transform: raw data lands in the target system first and is transformed there. See ETL for the opposite order.
Related terms
- azure/sql-action
Used in GitHub workflows to publish a SQL project or
.dacpacto SQL Server or an Azure SQL database; it is a wrapper round SqlPackage. - DacFx
The Microsoft framework underneath SQL database projects, SqlPackage and schema comparison, which compiles SQL object definitions into a
.dacpacpackage and deploys it to a target database. Both SQL database in Fabric and Fabric Data Warehouse are supported targets.