Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

A Reporting System Architecture Expand / Collapse
Author
Message
Posted Wednesday, October 6, 2010 7:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:04 PM
Points: 110, Visits: 496
Good Morning....

thanks for the comment.

You could use Trnxn-Replication to copy the data to your staging server and then SSIS to ETL the data from the staging server to you reporting DB.

Mirroring could work too, depending on exact requirements and how often you wanteed to back up your transaction logs.


Hope this helps...

GAJ


Gregory A Jackson MBA, CSM
Post #999301
Posted Wednesday, October 6, 2010 7:59 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 563, Visits: 1,012
GregoryAJackson (10/6/2010)
Good Morning....

thanks for the comment.

You could use Trnxn-Replication to copy the data to your staging server and then SSIS to ETL the data from the staging server to you reporting DB.

Mirroring could work too, depending on exact requirements and how often you wanteed to back up your transaction logs.


Hope this helps...

GAJ


Im leaning more towards replication, because of the low latency. Log shipping would not work because of the latency. Not sure about the mirror (and snap) approach, I need to do this to 700GBs worth of data.
Post #999332
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse