When I publish the SQL Server Database Project in Visual Studio it generates a DeploymentReport.txt file which includes a preview of the changes to apply.
When I publish using MSBuild the file is not created (But the deployment works and all changes are applied).
The Deployment Report is important for me as it warns me about any unsafe changes that might ocuur.
Does anyone know how I can force MSBuild to generate this file ??
The command I’m running:
MSBuild /t:build,deploy /p:TargetDatabaseName=”School”;TargetConnectionString=”…” /p:SqlPublishProfilePath=”…School.publish.xml”
Using Visual Studio
Using MSBuild
I tried searching online for a solution, but I couldn’t find any relevant solution.
Then I looked into the MS Build documentation but it didn’t have any information about what I needed.
I also tried to find any properties specific for the deployment report in the .target files but also didn’t help.