Database design to enable revision handling

  • Thread starter Thread starter Tobias Gårdner
  • Start date Start date
T

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
 
Back
Top