Difference between bacpac and dacpac for SQL Server

Understand the difference in the types of SQL Server export

John Savill

April 30, 2017

1 Min Read
Difference between bacpac and dacpac for SQL Server

Q. What is the difference between a bacpac and dacpac with SQL export?

A. It is simple to export a SQL Server database which may be required to import to another server or even for longer term retention. There are two primary types of export file, bacpac and dacpac.

A bacpac includes the schema and data from the database. A dacpac containers only the schema and not the data. Note that the schema really comprises of everything NOT data, for example the actual table definitions of the database, views, stored procedures, functions etc.

About the Author(s)

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like