Hi,

I'm the original poster.  Thank you all for your input it has been very helpful/insightful.

Going into this post, I was leaning towards replication because we have our sister companies replicating...

I'm not too worried about having some data latency because this will be a bulk overnight job that only runs once at night.  I just need to to be completed...

Just a quick estimate, I am estimating 20-30 tables that we will need to query.

That is correct.

Tim