Home

Welcome to the TriggerMan Wiki!

TriggerMan is a tool for Audit Table and Trigger Management in MySQL.
TriggerMan can:

•Read table and trigger definitions from the Information_Schema database. The user never has to enter table/column definition data when creating audit tables or triggers, or create scripts.

•List existing tables and TriggerMan objects in a schema, and allow the user to choose which ones to operate on.

•Given a table, it can dynamically generate a corresponding audit table. This audit table contains specified columns from the original table, plus additional auditing information columns, such as when changes were made, and by whom.

•After creating an audit table, it can create triggers on the original table which control how and when data is written to the audit table; for example, Before Update or After Insert.

•Apply processing to multiple objects in a single operation.

•When a table’s structure changes, pushing a few buttons rebuilds both the audit table and associated triggers, with no loss of audit trail data.

TriggerMan Usage:

Distribution:

TriggerMan is distributed as a 7-zip (.7z ) file; most Zip-type tools can be used to open it. 7-zip is freely available from www.7-zip.org.

The top-level TriggerMan folder and subfolders are structured as a NetBeans project. The top-level folder also contains two important files:

TriggerMan Users Guide.doc – This document.
TriggerMan.sql – MySQL Installation file.

The /dist subdirectory contains the TriggerMan executable file. The README file describes in detail how to run it.

The wiki uses Markdown syntax.

Project Members:

• Dave Hutira (admin)