TriggerMan Icon

TriggerMan

An Audit Table and Trigger Management Tool for MySQL

Add a Review
1 Download (This Week)
Last Update:
Download TriggerMan.7z
Browse All Files

Screenshots

Description

TriggerMan is intended to simplify the task of creating basic audit tables and triggers 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.

TriggerMan Web Site

Features

  • • 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 all 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.

KEEP ME UPDATED

Write a Review

User Reviews

Be the first to post a review of TriggerMan!

Additional Project Details

Languages

English

Intended Audience

Developers

User Interface

Java Swing

Programming Language

Java

Registered

2013-04-23
Screenshots can attract more users to your project.
Features can attract more users to your project.