Re: Can I historize tables?

urswagner_at_bluemail.ch (Urs) wrote in message news:<d817deb6.0209130343.175dd83f_at_posting.google.com>...
> Hello
>
> I have always to import some code tables from another system.
>
> I would like to save the old tables content. Because sometimes I have
> to go back to the old version?
>
> What is the best way to do this?

Well, you could

• create an "old version" table (tblOld)
• insert into tblOld select * from tblCurrent
• truncate table tblCurrent
• insert into tblCurrent select * from <table on other system>

You could also add a version column to the table that indicated whether the data was old or new (this would be more flexible if you wanted to maintain multiple historical versions). You could then write views on that table that showed just the old data or just the new data. If there is a lot of data, you may want to partition the table by version.

Justin Cave Received on Sat Sep 14 2002 - 00:21:15 CEST