Database design to enable revision handling

[Tobias Gårdner]

Hi,

I work with data that is constantly changing. I would like to be able to
track those changes and make reports on what has changed. The database
design that I am setting up consists of several tables where I would like to
add some sort of revision control.

What is the best way to do this? To add a column in each table with revision
information (e.g. dateTime when updated)? Is there a way of creating
replicas of the database and to diff the content of a replica towards the
live database?

Any ideas are welcome.

Best regards,
Tobias Gårdner

 

[John Nurick]

Hi Tobias,

One approach is on Allen Brown's site at
http://members.iinet.net.au/~allenbrowne/tips.html

Look for "Audit Trail" under "Specific Applications".