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

Best Replication Strategy for this scenraio ? Expand / Collapse
Posted Wednesday, January 30, 2008 9:58 AM


Group: General Forum Members
Last Login: Thursday, April 2, 2009 6:57 AM
Points: 144, Visits: 666
Hi All,

We have a Data Warehouse on a SQL 2005 Enterprise 64 bit Clustered SAN Environment. We have a need to maintain a separate database on a separate SAN which has all the same data contained in the Data Warehouse (this includes the Staging Data as well as BI data) but on a rolling 6 month basis (only the most recent 6 months of data). We do have an Inserted Date column on these tables in the DW.

Would Snapshot Replication be appropriate for this scenario with a filter to pull only the most recent 6 months of data? The Largest tables have about 26 million and 16 million rows, respectively for the most recent 6 months. Does this seem like too much for a Snapshot. Might Transactional be better?

A few hundred thousand rows are processed daily for these larger tables in batch processing at 6:00 a.m.

I'm new to replication, so any help would be much appreciated. Our alternative is to create ETL Scripts to handle the Process. Thanks.

Post #449525
Posted Thursday, January 31, 2008 6:52 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 8:13 AM
Points: 1,278, Visits: 2,204
How big is your dataset (6 months data volume for replication)? Estimate how long it will take for snapshot.

Does the user needs view the replicated data in real time (close to real time)? or a couple hours delay is fine?

Post #450264
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse