DLM Dashboard

DLM Dashboard (previously called SQL Lighthouse) is a tool that monitors your database schemas in order to alert you about unexpected changes – often called database drift. Once alerted, users can choose to take remedial action. This might be to rollback the change, apply it to another database or script the change into version control. To find out more about what DLM Dashboard does and how it works, please visit our “website”: http://www.red-gate.com/products/dlm/dlm-dashboard/.

If you have any questions or need help with Redgate’s free tool DLM Dashboard, please visit our “support forums”: http://www.red-gate.com/MessageBoard/viewforum.php?f=176.

Suggest a new feature or enhancement...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Stop page refresh. I can't get through even a short change without the page refreshing.

    Stop page refresh. I can't get through even a short change without the page refreshing. If there is a way to turn it off, I can't find it.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Enable databases to be part of multiple pipelines

    I am using 'Category' to group my databases by data stage / purpose ('Reference' 'Application' 'ETL' 'Analysis'), and I would like to be able to assign a single 'reference' database to multiple pipelines.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Color Code Categories

    It would be great to be able to color code categories so that they are easily identifiable in the pipeline view. For my use case, I have categories assigned to 'Reference' 'Application' 'ETL/Prep' 'Analysis' and I use my pipeline view to visualize the flow (I know this isnt the tool for lineage..).

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. skip some notifications

    We have an old vendor that temporarily creates and deleted tables (instead of using #temp Tables), so I get notification every time the app creates and drops one of those tables...would be nice to be able to filter those out...maybe filter to ignore objects named TABLE.MultiSelect*

    Handy tool though!

    Thanks!
    -R

    -- This file was downloaded from DLM Dashboard. It's the SQL that the user Shelby ran on the database ShelbyDB (server svrsqlent):

    CREATE TABLE MultiSelect201078 (
    Sequence int ,
    [Counter] int NOT NULL ,
    [Selected] smallint NOT NULL ,
    [Fund] varchar(6) NOT NULL ,
    [Fund Name] varchar(50) NOT NULL…

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  5. SQL Server Management Studio 2018 support

    Please make the Search feature consistent with Microsoft SQL Server Management Studio 2018. Thank you very much in advance!

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  6. Don't require creation of RedGate database

    I can't justify a tool that needs to place a new database on every server that I monitor. Either let me pick one location for the environment that can be placed anywhere, or have an option for a local express or file-based database. I really wanted to check this software out, but I can't...

    5 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Configure data retention per database

    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.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  8. Ability to see a list of objects changed within a drift set, and click that object name to jump to it in the page

    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.

    6 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  9. Ability to click the listed user on a drifted schema and filter to see just the changes made by them

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

    5 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  10. Enable editing server info or credentials

    Enable editing change server name or credentials in configuration panel for existing servers

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  11. Ability to APPROVE or DECLINE changes and then write and execute scripts to that effect

    A series of changes are shown. The DBA can either approve them, or decline them, and if decline, run reversal scripts as needed? May be too complex, but would be wonderful!

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  12. Ability to see when a change is reverted and remove the "reporting"

    I added a dumb test table. Red Gate caught it. Then I deleted it. Red Gate seemed to get lost. If the change and then removal/reversion could be tracked somehow possible, meaning this was a non-event, that'd be great.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  13. A Pause Button For Configuration\Servers Tab

    a pause button should be useful for Configuration\Servers\Databases or Servers screen. Somtimes we need to pause tracking db or server. But there is no option except edit/remove

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add ability to ignore contraints

    I would like to be able to tell DLM Dashboard not to alert when constraints don't match or are disabled. I manage a few databases where we disable constraints for data imports and then re-enable them afterwards. This is resulting in 2 email alerts per data load and training me to just ignore the alerts.

    Would it be possible to tell DLM either ignore constraints or don't alert if the constraints are there but no enabled?

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. ELK or Splunk

    ELK, Splunk, and Appinsights are better than email

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  16. Saving a schema name should be unique by category then by database.

    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."

    7 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  17. 4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  18. Ability to introduce a DACPAC to represent LIVE

    Our test environment can't see live, however we do get daily DACPACs from LIVE. Would it be possible to select a folder to use as 'live' rather than a server so we can compare to the Live DACPAC rather than the server?

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Ability to review changes over time.

    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.

    4 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add ability to control the frequency with which the DLM service polls the Redgate database.

    This polling process creates a fair amount of network traffic over time and for bandwidth limited remote sights that can cause an issue. Having ability to control how often (and when) schema changes are checked would go a long way in reducing this issue

    7 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

DLM Dashboard

Feedback and Knowledge Base