Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trend Rolling Table Expand / Collapse
Author
Message
Posted Thursday, December 6, 2012 9:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 18, 2015 12:25 PM
Points: 1,159, Visits: 558
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?
Post #1393624
Posted Friday, December 7, 2012 6:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 18, 2015 12:25 PM
Points: 1,159, Visits: 558
Debating on using replication or SSIS Lookup.
Post #1394292
Posted Friday, December 7, 2012 7:37 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 40,551, Visits: 37,797
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."

Helpful Links:
How to post code problems
How to post performance problems
Post #1394298
Posted Monday, December 10, 2012 4:17 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:29 PM
Points: 3,593, Visits: 5,852
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)

Prosecutor James Blackburn, in closing argument in the "Fatal Vision" murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."
Post #1394811
Posted Tuesday, December 11, 2012 11:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 18, 2015 12:25 PM
Points: 1,159, Visits: 558
SSIS lookup is working well.
Post #1395248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse