Skip to main content
Kofax

How to collect a SQL DACPAC file

3026573

Question / Problem: 

How do I collect a SQL DACPAC file?  

For reference per Microsoft, this is what a DACPAC is:

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database

A data-tier application (DAC) is a logical database management entity that defines all of the SQL Server objects - like tables, views, and instance objects, including logins - associated with a user's database. A DAC is a self-contained unit of SQL Server database deployment that enables data-tier developers and database administrators to package SQL Server objects into a portable artifact called a DAC package, also known as a DACPAC.

Statement above was retrieved from the following URL, but note the URL may differ over time:  https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver15

Answer / Solution: 

1. Log into SQL Server Management Studio

2. In SQL Server Management Studio, select each database in turn, right-click and select Extract Data-tier Application.  This will launch the Extract Data-tier wizard.

clipboard_e1e123b05768845aa1a3fb64d6412addf.png

 

3. Click Next.

clipboard_eb0beca292fec638e5de0d8417fb44459.png

 

4.  In the next screen, Set Properties, select a location to save the .dacpac file.  Click Next.

clipboard_e2c0faa9b75b71805f60b4648fe8d90c8.png

 

5.  In the next screen, you can review the settings and go back to change any if necessary.  Click Next.

clipboard_e143622e2bfeeaec309c653132ffa97ff.png

 

6.  In the next screen, progress will be shown as the package is built, and should report success once completed.  Click Finish to complete the process.

clipboard_e8e150187a5ebf3b96e4871a3f5d53e6e.png

 

 

Applies to:  

Product Version
KTA ALL