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 occur.
Does anyone know if and 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.