user_mobilelogo

 

Short description

DbDataHistory is a GUI tool for generating historical data of any database tables.

For this purpose the database must be configured first over an appropriate surface.

In the configuration phase the tables for which a historization is to take place are specified by the system administrator or persons with appropriate rights. In an automatic run, appropriate triggers and change tables are generated for these tables. As a result, data changes (not structural changes) to a table are recorded in the associated change table from this point on.

These changes can be specifically queried and visualized.

The administration of the generated triggers and change tables is also done via a GUI.

The tool should be able to cope with various database systems, but will initially only be implemented for the SQL Server.

 A preliminary description (originally intended for a demo) can be downloaded here (German language).