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.