Pages

Men

rh

10/16/2015

What files are generated from SSDT?

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.


source collected from mssqltips.com

No comments :

Post a Comment