Skip to content

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

31 results found

  1. Does not appear to be able to monitor databases. Can Add the instance but the databases are left in a pending state.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We improved set-up process for DLM Dashboard in 1.4.7 release. You can now add databases with one click using credentials from the connected server.

  3. Dashboard shows me sometimes changes made by the RedGate Souce Control that are only changes in the extended properties used by Source Control - e.g. EXEC spaddextendedproperty N'SQLSourceControl Database Revision', @RGSC_VERSION, NULL, NULL, NULL, NULL, NULL, NULL

    There are no other schema changes (e.g. because only something in static data table was changed), so please ignore your own in-house-changes and do not show me this stuff as drift :-)

    6 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. I've just setup the DLM Dashboard as a POC, and in doing so, I added a server, and then 4 databases from that server.

    I had to type in the credentials to access the database 5 times, which wasn't much fun.

    I would suggest that on the add server screen, it shows a list of databases and you can tick which ones you want to import.

    5 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Ruchika responded

    Hi,

    We’ve just released a new build 1.4.7 with a more streamlined setup. You can now add databases with one click using credentials from the connected server.

    Regards,

    Ruchika

  5. At present, the ui appears to use windows usernames/passwords over basic auth, with the only level of access being "Full access"

    It would be preferable to have the ability to grant specific users access and specific permissions. Whether this ties into AD or something else, i'm not too worried, but general open access is not great.

    17 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We are delighted to announce that you can now restrict DLM Dashboard access to specific individual active directory users and groups. Download the latest release to try out this feature.

  6. I'd like to be able to create/rename/delete categories. I don't have 5 levels of databases and I don't call them "Integration", "Testing", "Acceptance", etc.

    103 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Today i get the error: A duplicate column name ([dbo].A duplicate column name ([dbo].[MyCase_TB].ISIN) has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set. I think the program could figure this out byitself.

    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  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Ruchika responded

    Hi,

    We’ve just released a version 1.4.7 of DLM Dashboard that works for case-sensitive databases. You may have to remove and add the database again to make this feature work.

    Regards,

    Ruchika

  8. Show the date and time each change was made. This is important when several days have passed and a release happened during that time frame. By having the date and time each change was made, I can determine if the change should have occurred when it did.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  History  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Would it be possible to have a configuration option to remove certain changes from alerting i.e I don't need to know every time I do an update to statistics - We do this on a daily basis on all tables and it is quite misleading to see '290 tables' have changed.

    Thanks

    19 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  ·  Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Jonathan Hickford responded

    As as DLM Dashboard 1.5.2 you can add filters to ignore specific object changes. Statistics updates are now ignored by default

  10. When I try and add a SQL2008 v10.0.1600 it is saying

    "The DLM Dashboard only supports SQL Server 2008 and later"

    My guess is that I need to be on certain level of SP or CU to use DLM

    Dave

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 1) To simply view project state across the environments

    2) To simply view change details

    (neither role to be able to accept of reject changes)

    I can both roles providing good visibility for Managers and Project Managers etc. whilst leaving the current role for Change Managers.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We are delighted to announce that you can now restrict DLM Dashboard access to specific individual active directory users and groups. Download the latest release to try out this feature.

  12. The DLM dashboard shows all the changes that have been made.

    In some cases these don't cause schema changes - e.g. rebuilding indexes, updating statistics, etc. It would be useful to be able to filter these out, in a similar way to the filters available in SQL Compare / Data Compare.

    97 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We are excited to announce release of DLM Dashboard version 1.5.1.1125.

    This release supports ignoring changes to objects you’re not interested in by adding filters to your pipeline. This also includes filtering rebuilding indexes and updating statics. Filtered objects won’t trigger updates or drift, and aren’t included in email notifications or reported on the Review page.

    Thanks,
    DLM Dashboard Development Team

  13. We have the same database on multiple servers in the same environment.

    If one of those servers drifts then we can't tell which one it was from the dashboard.

    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  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Once there are many DB's in many environments in many projects it becomes practical if drifts are automatically flagged as a recognized part of a release. Using SQL Source control, migrations script i.e. become part of the SQL Release world as the watchdog that something escaped the CI / AD, or was illegally done.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We are excited to announce release of DLM Dashboard version 1.5.2.1135.

    This release contains improved integration between DLM Dashboard and other Redgate tools.

    Thanks,
    DLM Dashboard Development Team

  15. You need to add SET NOCOUNT ON to the top of the trigger. Otherwise you get the message "1 Row(s) Affected" when you create or alter objects, which confuses users. Who then come to me saying "I think I altered something that I didn't mean to."

    51 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. as it stands, anyone with access to the URL and port can review changes and modify configuration options. This is acceptable while testing locally, but needs at least the option to add a password if it is to be rolled out (say to a team of DBAs or to allow supervisors to monitor drift on their project)

    6 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We are delighted to announce that you can now restrict DLM Dashboard access to specific individual active directory users and groups. Download the latest release to try out this feature.

  17. There are other email configuration requests that are already posted, so I will not rehash them (I have read them all and agree with all of them as being desirable). One more to add that I did not see was the ability to have more than one email recipient. I do not want to have to resort to having our email system keep track of groups/lists for delivery of certain "types" of email items from Lighthouse. Maybe the ability to add comma/semi-colon separated list of individuals. Then, if that could be tied to the ability to have certain individual emails…

    8 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Just as it says, There is no need to store these procedures in the master database

    142 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Robin responded

    As of Dashboard 1.7.1, the default location for the stored procedures is the Redgate database, rather that the master database. Existing users can make the change through the in-app configuration area

  19. I've misspelled info in the State Description. Cannot figure out how to edit it.

    5 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  fiona.gazeley responded

    The ability to rename schemas from the history page has been available in DLM Dashboard since version 1.4.8. Apologies for the delay in updating this status.

  20. An ability to ignore objects beginning with or containing '$x$' would be useful.

    Example; my customer manages their own infrastructure but their supplier creates throw away stored procedures on the fly. These are identifiable but currently cause too many alerts for SQL Lighthouse to be useful.

    126 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    We are excited to announce release of DLM Dashboard version 1.5.1.1125.

    This release supports ignoring changes to objects you’re not interested in by adding filters to your pipeline. Filtered objects won’t trigger updates or drift, and aren’t included in email notifications or reported on the Review page.

    Thanks,
    DLM Dashboard Development Team

← Previous 1
  • Don't see your idea?