It would be great if DLM Dashboard had a limit on how many schema versions are retained in the database. Some of my databases change more frequently than others. The limit should be a default across all databases with the ability to override the default value on a per-server or per-database level.

in the list of changes at the top you get a summation of what was change (2 tables, 2 stored procs, etc). would be nice to actually have those listed out by names, and have those names be a link to where you could click them and jump to that specific object's details lower on the page. in short, lessen the need to aimlessly scroll.

Each drift shows the user who made changes, but you cannot filter to just that user's changes. Makes for a lot of scrolling.

When acknowledging changes, it appears that you can't use the same schema name across databases in different categories.

Example:

Development
MYDB
Save schema named '01/09/2018'

Production
MYDB
Save schema named '01/09/2018'
** Result in error "There is already a schema saved with this name."

I would like a way to enter an object name (stored proc, table,...) and see the changes that have occurred over a specific time frame whether or not the changes have been accepted.

I just did a new release which had a lot of changes in it. Now I can't acknowledge those change because the refresh rate of the system is to tight. Either need to be able to turn it off for a bit or change the rate so that I have time to put a version number and comment in and click acknowledge.

It would be useful if the changed objects could be listed without the T-SQL code being displayed.
Some form of a toggle switch so that the code could be hidden/displayed would suffice

The 50 database limit makes this product a non-starter in our shop. We have over 300 databases that need monitoring. We would even be willing to pay for a 'Pro' version of this product if this limitation was removed.

Suppress common event types that are not going to be actionable and frequently seen due to maintenance.

These cause extra traffic and fill the history without benefit.

Something like:
DECLARE @eventdata XML = EVENTDATA();
DECLARE @eventType SYSNAME = @EventData.value('(/EVENTINSTANCE/EventType)[1]', 'nvarchar(128)')
IF (@eventType NOT IN ('ALTERINDEX', 'UPDATE_STATISTICS'))
BEGIN

When the SQL Object "code" is really wide, it exapands the entire web page to the point of not seeing the "NOW" portion of the window. Can you add scrollbars at the bottom of the WAS and NOW portion of the web page for each SQL Object change?

Can you add the ability to track user permission changes at the database level?
Example: I temporary give Joe write access to the database. I can accept the change in DLM Dashboard with the reason why the change was made in permissions.

The installation script should allow the DBA to configure how many events (rows) are stored/retained in the DDL_Events table. As-is, the install script checks for row-count over 512, and if so, deletes the last 420 rows. This should be configurable by the DBA, especially if he/she wants to be able to examine the "raw" event data written to the table instead of / in addition to using the Dashboard GUI.

etsa oum gre he nouck vra oum kclouck ok !

I cant seem to see more than a couple hours EVERY CRISIS like what we just had and found to be the SAPHOS Client, but everyone was claiming it was SQL, what changed last week compared to today/?? I cant provide that.

Hi

Is there a way to get the whole SQL corresponding to all changes, in one file?

Thanks

Regards

For example we have a changeset like:

Version 1.3: Add Missing Indexes

And this script would be run on all pipelines but each Schema drift would have to be named differently which is just confusing for users it would be great to see the same name in each pipeline for the same changeset.

show find change history of single objects, (who, when and what has changed on an explicit object.)

It would be great if the hostname who made the change was included, incase people use the same login name. We have developers who all use the same login e.g. developer so seeing who made the change is not possible, as it says login name developer but can it also include hostname e.g. pauls-laptop

So I decided I didn't want to monitor a certain server no more so removed the server from my list but it has not removed the RedGate database, and I guess therefore hasn't removed the DDL trigger etc.... This is just utterly ridiculous and really needs urgently changing. That's the DLM Dashboard now uninstalled..!!!