DB Schema Monitoring periodically polls your cloud databases and alerts designated recipients if DDL changes are detected—giving you the opportunity to take proactive measures.

DB Schema monitoring is available as a standalone product within the SqlDBM platform. Please contact the sales team if you are interested in trying this service.

DB Schema Monitoring can be managed by account admins from the Account screen. You can access the account screen from the Dashboard.

Next, select "DB Schema Monitoring" from the menu.

A monitoring job is like a scheduled Reverse Engineering using saved Direct Connect credentials. A job periodically polls your cloud database schemas for changes and sends email notifications to designated recipients (only) when DDL changes are detected.

Create a job by following the steps indicated in the video:

Job runs and changes can be viewed by clicking the arrow icon to the left of the job name.

Logs (right) record every scheduled or on-demand run of a given job.

To see the complete history of job runs, click "See all logs".

Last changes (left) only appear for job executions where changes were detected.

To review change details, click "Compare".

The compare changes screen for monitoring jobs works like SqlDBM's compare revisions. Any two versions can be compared, and their differences highlighted. For more on compare revisions, see the related article below.

Monitoring job actions can be accessed from the three-dot menu to the right of a job. These include:

When changes are detected during a monitoring job, recipients are sent an email summarizing the details. To view the full list of changes in the compare changes screen, follow the "Compare the changes" link from the email.

See also: