mardi 28 juillet 2015

Audit history for changes in Db Row

Scenario:

I have a database table, any changes on data of any column of this table needs to be audit logged for comparison purposes.

What I have tried:

I have a history table with the same values columns as the parent table and any change to the database gets recorded into the new table using triggers and I eventually achieve what I want.

Problem

The issue is multi-fold:

  • I am using triggers which I do not want to use.
  • If I have to have audit comparison for n more tables, then I need to have one history table per parent table and which just swells my database and makes it bulky with so many tables.

Is there a better approach of achieving this, please suggest?

Aucun commentaire:

Enregistrer un commentaire