Export file holding both the schema and the data of a SQL database. Because the export is only consistent if nothing writes to the database meanwhile (or if you export from a copy), it counts as an offline migration method.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains BACPAC in context, with comparison tables and the common traps.
Terms in this definition
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA. - 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.