Change history/log for each instance
I want to see a history of all the changes that have happened in an environment. It should show version names and dates, and I want to be able to drill into each change to see the diffs.
In version 1.2 you can now see a history of the previous schemas that have been present on a database. You can see the differences between them, who changed the objects and who approved the new schema.
PS. SQL Lighthouse has been renamed to DLM Dashboard. Find out more and download the latest version on http://www.red-gate.com/products/dlm/dlm-dashboard/
I definitely think that some integration with the SQL Compare engine would be very valuable. Currently, when you add databases to SQL Lighthouse and they are different, the yellow warning message tells you they are different, but provides no details. From here, a list of differences inline on the website would be very useful---or some integration that launches SQL Compare, which then shows the differences that triggered the warning.
I like the idea of the differences being summarized directly on the web site, which would be quick & easy to review. The ability to open SQL Compare would be very handy, but not always needed (so it could be an optional link).
Additional details on change history, version history, and associated change details would be icing on the cake for this.