database structure and asp for archiving records

database structure and asp for archiving records

am 15.10.2004 08:22:26 von anniesraar

Hello,

For a current project I have to store changes in records and display
the changes accordingly in asp. I have a table with 10 records and
ItemId is primary key. What is the best way to keep track of changes
to the records? Everyday all 10 records are provided again and then I
have to check what the changes are and store them. I assume I have to
create another table with 11 records, only having to add a VersionId.
Do I have to only write the changed records or is there a better way.
Furthermore, is there an easy way to compare records and display the
changes. Say I have 5 versions of records how can I compare the
changes and display them for each set of records. I just need a
pointer in the right direction.

Cheers.
Pascal