Database Mapper Scheduling a Snapshot

Update: SentryOne Document is now SolarWinds Database Mapper (DMR). See the Database Mapper product page to learn more about features and licensing. Want to explore Database Mapper? An interactive demo environment is available without any signup requirements.


With SolarWinds Database Mapper, you can schedule snapshots to occur at a time of your choosing. This can be useful for automating the snapshot process, and to continually update documentation for your data sources at consistent intervals. For example, you may want to schedule a snapshot weekly for a dev server to document the changes that occur on a weekly basis. 

Additional Information: For information about:

To begin scheduling a snapshot for your selected remote agent, complete the following steps:

1. Open the Solutions dashboard, and select the Configure Snapshot button for the desired solution to open the Snapshot Configuration window. Copy the first snapshot command.

Database Mapper Solutions Dashboard Configure Snapshot
Database Mapper Snapshot Configuration window Copy first command line

2. Open the Database Mapper install directory, select SHIFT+ Right Click to open the context menu, and then select the Open PowerShell window here option.Database Mapper File Directory Open Powershell window

Note:  In this example, the install directory is C:\Program Files (x86)\SentryOne\Database Mapper Remote Agent. Database Mapper uses this by default.

3. Paste and execute the copied command. Go back to Database Mapper, then copy the second snapshot command.

Database Mapper Execute Command in Powershell
Database Mapper Snapshot Configuration window copy second command
Only Copy the highlighted portion

Note:  You only need to copy the argument. You don't need to copy the whole statement including the .exe.

Important:  You need to copy the argument starting with the word snapshot through the end of the argument. For example, you would only copy the highlighted portion as shown in the snapshot configuration image above. The code snippet provided below is only an example: 

snapshot -s e42684e9-f8aa-4881-9915-26443a852f9f -t https://s1dhost-dev-eus-as.azurewebsites.net/ -o 6d1ff543-dec2-47dc-8a1b-965038adcbc6

4. Open Windows Task Scheduler and select Action > Create basic Task to open the Create Basic Task Wizard.Database Mapper Create Basic Task

5. Enter a name and description. Select Next to continue. Database Mapper Basic Task Wizard Enter name

6. Select a task starting point and select Next. Configure your trigger, then select Next to continue.

Database Mapper Basic Task Wizard select Trigger
Database Mapper Basic Task Wizard configure Trigger

7. Select Start a program for the action, then select Next. Select Browse to open remote agent install directory, then select the SentryOneCommandLine.exe. Paste the previously copied Snapshot Configuration command in the Arguments box. Select Next to continue. 

Database Mapper Basic Task Wizard Start a Program action
Database Mapper Basic Task Wizard Configure Action

Important:  You need to paste the argument that you copied in Step 3 in the Add arguments (optional) field. For example, you would only paste the highlighted portion as shown in the snapshot configuration image in Step 3. The code snippet provided below is only an example: 

snapshot -s e42684e9-f8aa-4881-9915-26443a852f9f -t https://s1dhost-dev-eus-as.azurewebsites.net/ -o 6d1ff543-dec2-47dc-8a1b-965038adcbc6

8. Select Finish to save your task.  

Database Mapper Basic Task Wizard select Finish

Success: Your Database Mapper Snapshot is now scheduled!Database Mapper Snapshot Scheduled