Posted by Curt on 11/29/06 20:09

I am planning a replication project where we will be rolling up data
from several (about 5) offices into a central database that will be
used for management reporting. The tables I want to replicate are
identical in each of the offices (there are 8 tables right now).
Ideally I would like the final product to be 8 tables in the Subscriber
database, each table containing data from the 5 offices.

Since I am new to replication, I was wondering if it is possible for
each of the 5 offices to sychronize with the 8 tables in the Subscriber
database? Or is it necessary to have a separate set of 8 tables for
each office? If that is the case, then I would have to UNION the
tables in the Subscriber database, which I would rather not do if I
don't have to.

[Back to original message]