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.

DLM Dashboard

Categories

JUMP TO ANOTHER FORUM

  1. t would be nice to have the functionality to create ONE FILE containing ALL the changes that have been done to cause a certain drift in the database version. I noticed currently it gives me the option to download a file for each change done individually, but very often these changes can amount to quite a large number, and having to download hundreds of files is not really practical.
    Having all the changes "downloadable" as one file would be a huge benefit.
    Adding more to that functionality, as I've already seen people suggested: to have the option to "pick and…

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  2. then can have full record of changes in designated mailbox. Option similar to more customization of email notifications.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  3. If the setup script is executed manually the service accounts should not need to have sysadmin access. Today it requires that access because it is mandatory to validate the objects existence before the server is added.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. E.g. each user who mades the changes can approve his/her own changes in the snapshot.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Would it be possible to enhance the summary to behave like a navigation index? Something like:

    Objects changed since DATABASE's schema on 3/1/2015
    - Tables (2)
    - Table1
    - Table2
    - Procedures (2)
    - Proc1
    - Proc2
    + Functions (1)

    Then if I click on one particular object it will jump to that object's script.

    Right now we have to scroll all way down in order to get to a particular object's script.

    Thanks,

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Hi! Some times I'm receiving an email for each change in any object in same Environment/Database, if my team modified 3 stored procedures I received 3 emails, but some times I'm receiving only one email...
    It depends of the difference of time between each change.. or depending of the user... ?
    What is the criteria to group the changes in email alerts for the same Environment/Database?
    So my idea is to have something to edit this feature.
    Thanks!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  7. the email should list which sql object actually changed. not just 1 table name, but the actual table name

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  8. Provide more info in the email alert to avoid having to open the website

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  9. We use tempDB extensively, creating tables, deleting tables and building indexes. It creates a lot of noise in the Event table. The trigger should exclude DDL activity in tempDB from being written to the Event table.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  10. It would be nice if the drift comparison could be exported to PDF or HTML in the same way that the Red Gate SQL compare does.

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  11. Hi! I would like to see who made the change in the email alert.

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  12. I'm not sure I like the Project >> Environment >> Server >> Database hierarchy.

    The way the check works doesn't make sense to me with the suggested categorization hierarchy.

    If I have a project (P1), with an environment (Prod), a server (S1), and 3 databases (D1, D2, D3). All of these databases are part of the same project (P1).

    Then another environment of (Dev) with the same databases on another server. I want to compare the respective Dev D1 to the respective Prod D1. That's how it logically organizes to me.

    I add the databases that way and it will…

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →

    We’re planning to improve the way you can organize database later this year. The current projects mechanism is limited. Please do leave us any comments with your thoughts on how we can make this better

  13. I would very much prefer "silent" notification, instead of an email.
    I guess it would require a server side component, but benefits are also, that all team members could get immediate notification this way.
    Like TFS, the icon in the tray area, could shift icon/color, when troubles are discovered.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  14. Move the C:\ProgamData folder for lighthouse to another drive to save space.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. I want to be able to add hotfix changes made in production into source control, so that they don't get deleted when I next deploy

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  16. I don't have an internal SMTP server I can use for sending alerts. An external service that I don't need to configure would be a lot easier for me.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
  17. I'd like to be able to acknowledge a state as being ok, without having to give it a name.

    66 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. I'd like to be able to mark certain states as being milestones. These are important states that I'd like to see a history of

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
  19. Instead of showing 'schema not recognized' automatically generate a name for that state, for example a version number like v1, v2, v3 etc.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
  20. When you add a server could you create an SQL Account for the application to use? This would assign the basic minimum permissions that are needed. This should be fairly easy as the set up has to be done by someone with sysadmin to the server. The details could be stored in the RedGate database, against the server with the password encrypted or hashed.
    Then when you add a database it could create a role and add the application account to the role as part of the setup to make it quicker.

    This would streamline the setup procedure, but you…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?