Skip to content

Database schema monitoring

With the Versio.DatabaseSchema importer you can import database schemas in Versio.io to detect changes and ensure auditability.

Based on freely definable rules the Versio.io solution Governance, compliance & risk allows you to perform additional content checks (e.g. proving the compliance with naming conventions).

Supported DBMS

The database schema monitoring supports the following common relational database management systems (DBMS):

  • Oracle database
  • Microsoft SQL
  • MySQL
  • MariaDB
  • PostgreSQL

Configuration

You can find the configuration option in Versio.io under Settings > Monitor > Database schema.

The following configuration parameter are required:

  • Database management system (DBMS)
    • Type (see supported DBMS)
    • Host and port
    • User and password with rights to read the database schemas
  • List of database schemas that should be monitored
  • Import frequency

Execution

Database schema monitoring can be performed by Versio.io or any other host. It is only important that the database is accessible from the executing host.