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.