.BACPAC File Extension

Compressed Microsoft SQL Database

Developer Microsoft
Popularity
3.0  |  1 Vote
 

What is a BACPAC file?

A BACPAC file is a Zip-compressed archive that contains a Microsoft SQL database's schema and data. Users export BACPAC files from and import BACPAC files into Microsoft SQL database programs, such as Microsoft Azure SQL Database and Microsoft SQL Server. BACPAC files are used to transfer databases between servers.

More Information

Database managers can use a variety of Microsoft SQL database management tools to export databases as BACPAC files. For example:

  • Azure users can export a database as a BACPAC file from the Azure portal
  • SQL Database users can export a database as a BACPAC file using the SqlPackage command-line utility
  • SQL Server Management Studio users can export a database as a BACPAC file using a wizard included in that application

While BACPAC files are similar to .DACPAC files, the files are used for different purposes. BACPAC files are used primarily to back up or move databases from one server to another. DACPAC files are focused on capturing and deploying schema. Sometimes, DACPAC files are applied to existing databases.

How to open a BACPAC file

You can import the database a BACPAC file contains into Microsoft Azure SQL Database or Microsoft SQL Server. To do so, you must use either:

  • The Import Data-tier Application menu item (found by opening Object Explorer, right-clicking on Databases, and then selecting Import Data-tier Application) available in Microsoft SQL Server (Windows)
  • The Import database option available in the SQL server section of the Microsoft Azure portal
  • The SqlPackage command-line utility
Open over 400 file formats with File Viewer Plus.Free Download

Programs that open BACPAC files

Verified by FileInfo.com

The FileInfo.com team has independently researched the Compressed Microsoft SQL Database file format and Windows apps listed on this page. Our goal is 100% accuracy and we only publish information about file types that we have verified.

If you would like to suggest any additions or updates to this page, please let us know.