SSDT - Track database changes from DACPAC deployment

Question

I'm using Visual Studio 2017 and TFS 2015 to create an SSDT project and deploy the DACPAC via TFS.

If I test the project in Visual Studio by publishing a profile, I'm able to view all the changes to the destination database (ex. Dropping Tables, etc) in the "Messages" tab.

I'm not seeing that same kind of output when I publish the DACPAC through TFS. There are timestamps when Deployment has started and finished, but no information on what is actually modified in the database.

Is there anywhere I can view a log of database changes that occurred when a DACPAC was published?

EDIT: I'm using a WinRM - SQL Server DB Deployment task in TFS Release Management to deploy the DACPAC.

Answer 1

You could add a command line task to use SqlPackage.exe tool to generate a difference report between database. The syntax is:

/Action:DeployReport /SourceFile:$dacpac-path /TargetConnectionString:$constr /OutputPath:$reportoutputfilepath

Useful links:

• https://msdn.microsoft.com/en-us/hh550080(v=vs.103).aspx
• https://www.francoisdelport.com/2016/06/continuous-deployment-of-databases-part-2-sqlpackage-exe/