Re: how to design versioning?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 23 Sep 2002 16:13:43 GMT
Message-ID: <3D8F3DAE.84B67418@exesolutions.com>

david chan wrote:

> 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

Doable. But it not my method of preference.

What I prefer is an AFTER UPDATE OR DELETE trigger on the table that archives :OLD.field_names to a separate table along with the date-time and user responsible for the update or deletion.

Daniel Morgan Received on Mon Sep 23 2002 - 11:13:43 CDT