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).
The database schema monitoring supports the following common relational database management systems (DBMS):
- Oracle database
- Microsoft SQL
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
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.