Include identical objects in change report
Published 21 May 2018
By default the Changes.html report that's created as part of the database deployment resource doesn't include identical objects. You can include them by adding a parameter to the New-DatabaseReleaseArtifact cmdlet or the Octopus Deploy step template.
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