Retired products

Changing the directory that DLM Dashboard uses to store RavenDB files

By default, DLM Dashboard stores RavenDB files locally in the following directory: %ProgramData% \Red Gate\SQL Lighthouse\RavenDB. To change this, you first need to move the existing files, then configure DLM Dashboard to use the new location.

  1. Open Windows Services (services.msc). Right-click the following services and choose Stop:
    • DLM Dashboard Storage Service
    • DLM Dashboard Monitoring Service
    • DLM Dashboard Web Server
  2. Navigate to %ProgramData% \Red Gate\SQL Lighthouse\RavenDB and copy the contents to the new directory you want to use.
  3. Navigate to C:\Program Files (x86)\Red Gate\DLM Dashboard 1\StorageService

  4. If there's a file called UserSettings.config in the folder:
    1. Open the file in a text editor, running as administrator (right-click and select Run as administrator):
    2. Inside the <appSettings> node, copy and paste the following.

      <add key="Storage.DataDirectory" value="%ProgramData% \Red Gate\SQL Lighthouse\RavenDB" />
    3. Edit the value to the RavenDB folder in the new location you want to use.
      eg "C:\DLMDB\RavenDB"

  5. If the file doesn't exist: 
    1. Open a text editor, running as administrator (right-click and select Run as administrator):
    2. Create a new file. 
    3. Save the file as UserSettings.config in the folder C:\Program Files (x86)\Red Gate\DLM Dashboard 1\StorageService
    4. In the file, copy and paste the following:

      <?xml version="1.0" encoding="utf-8"?>
          <appSettings>
      <add key="Storage.DataDirectory" value="%ProgramData%\Red Gate\SQL Lighthouse\RavenDB" />
      </appSettings>
    5. Inside the <appSettings> node, edit the value of the key Storage.DataDirectory to the RavenDB folder in the new location you want to use. 
      eg "C:\DLMDB\RavenDB"

      DLM Dashboard needs permission to read and write to the new directory. To grant these permissions, open a command line running as administrator, and run the following, replacing the directory with your new directory:
      Icacls "C:\DLMDB" /grant "NT SERVICE\RedGate.SQLLighthouse.StorageService":(OI)(CI)M


  6. Open Windows Services (services.msc). Right-click the following services and choose Start:
      • DLM Dashboard Storage Service
      • DLM Dashboard Monitoring Service
      • DLM Dashboard Web Server

DLM Dashboard will now use the new location to store RavenDB files locally.


Didn't find what you were looking for?