Post reply

Trend Rolling Table

  • December 6, 2012 at 9:52 am

    #267801

    Development has created 7 day rolling tables on multiple servers. I want to pull this data over to another table so I can trend daily averages over a few months. The rolling table is populated throughout the day meaning data is added/removed every few minutes. What would be the best method to copy this data to my table without missing or creating duplicate rows?

  • December 7, 2012 at 6:50 pm

    #1566812

    Debating on using replication or SSIS Lookup.

  • December 7, 2012 at 7:37 pm

    #1566818

    Erin-489205 (12/6/2012)

    Development has created 7 day rolling tables on multiple servers. I want to pull this data over to another table so I can trend daily averages over a few months. The rolling table is populated throughout the day meaning data is added/removed every few minutes. What would be the best method to copy this data to my table without missing or creating duplicate rows?

    Step 1 would be to find out how they are deleting the data so you can intercept it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 10, 2012 at 4:17 pm

    #1567199

    Replication could be problematic as SQL will replicate the DELETEs as well as the INSERTs.

    Also, do you need to capture UPDATE activity or just INSERTs?

    Finally, are you on Enterprise or Standard Edition?

    CDC could work well for this if you are on Ent Ed (unfortunately, CDC is not available on Std Ed).

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • December 11, 2012 at 11:02 am

    #1567553

    SSIS lookup is working well.

Viewing 5 posts - 1 through 4 (of 4 total)

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