Open BACPAC files in your browser
The file SqlPackage and SQL Server Management Studio export a database to, its schema and every row, and how Azure SQL databases move. Open one right here, with no server to import it into. Nothing leaves your device.
Or drop it anywhere on this page
What you'll see
Your database opens as a folder in the file list, its tables and views with their rows counted, and each table you pick opens in the grid.
- Every table and view in a folder • Rows counted
- Keys lead to the rows they point at
- Search • Every table at once
- Export • Save a table or the whole database
About BACPAC
A BACPAC is a whole database exported for moving: Azure SQL's portal and SqlPackage write one, and SQL Server Management Studio's Export Data-tier Application does on any SQL Server. A DACPAC, from Extract Data-tier Application or a Visual Studio database project, is the same package with the schema alone.
Inside, it is a ZIP: model.xml describes every table, column, key and procedure, Origin.xml says where and when it was exported, and a folder for each table holds its rows in BCP's native format, one value after another in SQL Server's own layout, the biggest values in files of their own.
Filepeek reads the package in your browser, each table's rows as they're unpacked, and opens it as a folder of its tables, each in a grid to sort, filter and search, with keys leading to the rows they point at. Export saves a table or the whole database as a SQLite file, a SQL dump or one Excel workbook, and a DACPAC shows its tables' columns and keys with no rows.
SQL Server BACPAC export
.bacpac • .dacpac
Format
- MIME type
- application/zip
- Made by
- Microsoft, for SQL Server and Azure SQL
- Released
- 2011
Inside the file
- Package
- A ZIP
- Schema
- model.xml
- Rows
- BCP's native format
- DACPAC
- The schema alone
Opens in every browser
Filepeek opens BACPAC and DACPAC files in Chrome, Edge, Firefox and Safari. On their own, browsers only download them, and only a SQL Server or Azure SQL imports them.
- YouChromeOpens through Filepeek
- YouEdgeOpens through Filepeek
- YouFirefoxOpens through Filepeek
- YouSafariOpens through Filepeek
Apps that open BACPAC
- WindowsSqlPackage or SQL Server Management Studio, which import it
- MacSqlPackage, which imports it into SQL Server or Azure SQL
- iPhone and iPadNo app opens it
- AndroidNo app opens it
Questions
How do I open a BACPAC without SQL Server?
Drop it on this page or choose Peek a BACPAC. Its tables show as a folder in the file list, each with its rows counted, and the one you pick opens as a grid, on any computer or phone.
How do I get a BACPAC of my Azure SQL database?
In the Azure portal, open the database and choose Export, or run SqlPackage with /Action:Export. The BACPAC it saves opens here as it is.
What's the difference between a BACPAC and a DACPAC?
A BACPAC holds the schema and every row, to move a database. A DACPAC holds only the schema, to deploy it, so it opens as its tables with their columns and keys but no rows.
Can I get my data out as Excel or CSV?
Yes. Export saves the table on show as CSV, Excel, JSON or Parquet, and every table at once as a ZIP of CSVs, one Excel workbook with a sheet for each table, a SQLite database or a SQL dump.
Why won't my BACPAC import into SQL Server?
SqlPackage stops when the server it imports into lacks a feature the database uses, which happens with a BACPAC from Azure SQL or a newer SQL Server. Filepeek reads its rows without importing anything.
How do I send a large BACPAC?
Most email stops at 20 to 25 MB. To send the whole file, upload it to Fileport and share the link. Your BACPAC arrives unchanged, and your recipient can start downloading before the upload finishes. It is free up to 20 GB with no account. You can also choose Send via Fileport here, which hands the open file over in a new tab.