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 06, 2010 7:44 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 12:33 PM
Points: 108, Visits: 490
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 06, 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: Wednesday, March 05, 2014 4:14 AM
Points: 563, Visits: 971
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