Post reply

Whether to go for triggers or batch processing

  • August 15, 2008 at 1:44 pm

    #197044

    Hi,

    My scenario is like this:

    I have already existing application tables and need to create some more tables for generating reports. The data needs to be populated in the report tables when there is a new data is inserted into the application tables or if there are any updates in the application tables.

    So, I am planning to write triggers on these tables, but I need to write no of triggers on different tables.

    My question is, is there any way I can do it as a batch process within database? Take all the updated and newly inserted data and populate the respective reports tables?

    Please help me here to find out whether to go for triggers or batch process. If yes, how can I do that?

    Thanks in advance.

    Thanks,

    Chandra

  • August 15, 2008 at 1:46 pm

    #858955

    Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums.

    No replies to this thread please. Direct replies to

    http://www.sqlservercentral.com/Forums/Topic553744-92-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 15, 2008 at 2:22 pm

    #858982

    Sorry for that...

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

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