Flyway audit logging
When audit logging is enabled with the migration.auditEnabled property, records are inserted into the following three tables:
- MT_AUDIT_TX
- MT_AUDIT_TX_HIST
- MT_AUDIT_TX_DET
Audit logging provides the following benefits when troubleshooting Flyway migration issues:
- It captures long SQL/DDL statements, which are broken into pieces into audit log (native Flyway 'schema_version' table has limit of 1000 chars for a script to be persisted).
- It captures OS user name of the person who runs the migration.