DLM Dashboard not recognising DLM Automation package

chris_godfree

Hi,

My DLM Dashboard is not recognising schema changes which are being fed from DLM Automation - I've read the instructions and other forum posts but can't see where to go next - can anyone help?

I have set-up a TFS Build and used the relevant options for DLM Dashboard Integration. I can see from the build log that the package has been sent successfully to DLM Dashboard and I can see the package in the SQLCompareSnapshots in the Raven database. I've looked at the nuget package and compared it to the database: I can see the expected change but also changes to the roles which a user is in (I have a filter in source control to ignore all users) - is this potentially the cause?

Chris

Eddie D

Hi Chris,
Thank you for your forum post.

By default DLM Dashboard will ignore changes to 'User properties' and 'Users permissions and role memberships'.
https://documentation.red-gate.com/display/DDB1/Changes+ignored+by+default

This means that the dashboard will not indicate an update or drift. Could this be the cause of the problem you are experiencing?

Many Thanks
Eddie

chris_godfree

Hi Eddie,

I don't think so in that I have a change to a database object in there too which should be getting identified.

Chris

Sergio R

Hi Chris,

When thing you can try is to go to the change that you're concerned about in schema history and then press 'hh' (h key twice), this will prompt you to download some diagnostic information, including two SQL Compare snapshots that you can compare in SQL Compare to determine what is finding different.

Thank you,

chris_godfree

Hi Sergio - I have contacted one of your colleagues directly who has been looking at this.