Post reply

Special trigger attempt

  • December 20, 2005 at 10:35 am

    #90256

    Hi,

    Well, I'm administrating the process of a datawarehousing database, and I need each time a row is updated into a table, that a trigger run and take the actual data of this row and insert it into a "archive table".

    The purpose is to build a archive for data, a update clean the data, and we don't want to have them clean up; We want to keep the trace into a backup table, for our application working in past time.

    How to build this trigger, can it be dynamic? There's is around 300 table, I would like to build my trigger one time, and applicable for all!

    Thanks people, please to read any advice!

  • December 21, 2005 at 2:23 pm

    #610962

    You need one trigger for each table.

    As there are about 300 of them, you probably want to work out what the trigger should look like for one table and then use something like xslt to do transformations to create the other 299.

    For that you need to understand how xslt works, and that is another story altogether.

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply