Data changes are missing from Changes.html report

AsafC

Hi,

when using New-DatabaseRelease without -IgnoreStaticData and then Export-DatabaseRelease, Update.sql script is created and it contains also static data updates.
However, Changes.html does not contain these data changes - it display only schema changes.
As Changes.html is used for reviewing the changes before apply them, it is problematic.

- 'Changes.html': Lists the database objects that will change as a result of running the 'Update.sql' script, and highlights SQL code differences for each object before and after the update.

Thanks, Asaf

Andrew Fraser

Hi Asaf,

We currently don't support showing changes to static data. You are correct that the description of Changes.html doesn't reflect this so I've updated it to explain that it doesn't include static data. If you would like to you could add this as a feature request on uservoice here.

Cheers,
Andrew

Tugberk

Hi AsafC,

With the SQL Release v1.2.1.2809 (which you can get with the DLM Automation Suite v1.2.0.2562: http://documentation.red-gate.com/displ ... e10th,2015), Changes.html now shows you the Static data changes. You can find the full release notes here: http://documentation.red-gate.com/displ ... e10th,2015

Also, you will see that we have a completely new changes report and we are working on improving it. You can find more information on this here: http://documentation.red-gate.com/displ ... ne3rd,2015

Let us know if you have any further questions and hope you will like the new report