When the script completes, you end up with a new database on the server that you configured in the dashboard. In the next screen you see, you get the question if you want to run the monitoring script yourself, or if you want the DLM Dashboard to run it: So if you want to use this in your environment, don’t use the sa account!!! If you start using the DLM Dashboard (or any other software), it’s bad practice to use the sa account. I’m using the sa account to connect to this server, because it’s on a stand-alone server. In this test, I’m going to start with configuring a Development environment:Īfter adding that, you need to add a server: DTAP stands for Development, Test, Acceptance and Production. So my project will contain my 4 environments (DTAP). I created a Sandbox project, in which eventually all my environments will be configured. When you click on “Set up DLM Dashboard”, you are redirected to the configuration page. There are also 3 Windows services installed: “DLM Dashboard Monitoring Service”, “DLM Dashboard Storage Service” and “DLM Dashboard Web Server”.Īfter the installation, the DLM Dashboard is started: These are used to host the webinterface of the DLM Dashboard, and the service needed for monitoring your environments and databases.
The most important things the installation folder (C:\Program Files (x86)\Red Gate\DLM Dashboard 1) contains are a webserver and a monitoring service.
#Red gate sql toolbelt copy database install#
When you download and install the Redgate DLM Dashboard, you get a number of things. In that Q&A, he answers a few open questions that will clarify the product and the future of this product. In the second half of this blog post, there is also a Q&A with a Product Marketer of Redgate.
And even though I find Redgate’s tools awesome, I’m still going to be brutally honest in this blog (and I know they appreciate that!). This tool allows you to: “monitor your database schemas and alerts you to schema changes, including database drift”. The artist formerly known as SQL Lighthouse, underwent a HUGE overhaul, and now goes by the name DLM Dashboard.