What files are generated from SSDT?


The act of publishing generates files that are used by SSDT to determine what database changes to apply. What files are generated?


Navigate to your project's bin directory. Under that folder will either be a Release and/or a Debug folder. Depending on your configuration choice, you will have one or the other. The tutorial's configuration choice is shown below:

Configuration Settings

In this case, I have a Debug folder. Drilling into it, we see the following files:

List of generated files
  • DeploymentReport.txt - A report of the publish actions that occurred
  • FutBol.dacpac - a compressed binary that includes all the objects and scripts that make up your database project
  • FutBol.dll - related to CLR development
  • FutBol.pdb - a debugging file produced by Visual Studio

The most interesting of these is the FutBol.dacpac file. Though it is a binary, it can be examined using archive programs such as WinZip and 7-Zip.

Unzip of generated files

Opening this file with 7-Zip, I can see the following files embedded within the dacpac:

List of dacpac files

The postdeploy.sql contains the content of the Script.PostDeployment.sql we created earlier in this tutorial. The model.xml file contains the data model of our project. SSDT uses this information to compare against the target instance and to determine what changes are required.

While this is fun to look at, you shouldn't manually adjust anything in these files.

Comments For This Article

get free sql tips
agree to terms