Include identical objects in change report
Published 31 July 2019
The Changes.html report that's created as part of the database deployment resource doesn't include identical objects by default. You can include them by adding a parameter to the New-DatabaseReleaseArtifact
cmdlet.
Using the SQL Change Automation cmdlets
If you use the SQL Change Automation cmdlets, in the New-DatabaseReleaseArtifact
cmdlet, add the -IncludeIdenticalsInReport
parameter:
Example
New-DatabaseReleaseArtifact -Source $test -Target $staging -IncludeIdenticalsInReport