how to design versioning?

From: david chan <davidchantf_at_hotmail.com>
Date: 23 Sep 2002 08:58:33 -0700
Message-ID: <dca7348f.0209230758.67ce6dc5@posting.google.com>

Hi,

I need to versioning my data in a way so that all version of record can be retrived later on. I have about 15 tables and only records in one table need occasional versioning (probally once per month for some records in that table).

I am thinking to add different version of records into same table but each record with a version date (so the record with nearest date is latest version).
Is it a doable approach or anyone has different idea?

Thanks.
David Received on Mon Sep 23 2002 - 10:58:33 CDT