mssqltips logo

What files are generated from SSDT?



By:

Overview

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

Explanation

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.


Last Update: 7/22/2014




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools