Creating a Corporate Rollup Application

You can create a corporate rollup application from distributed primary fragments.

1. Activate a Replication Agent at each primary site. However, you do not need to activate a Replication Agent at the central site, since data is not replicated from that site.
2. Create tables in each primary database and in the database at the central site.
3. Allow for replication on tables at each remote database where primary data is stored.
4. Create replication definitions for tables at each remote site where primary data is stored.
5. At the headquarters site, where the data is to be consolidated, create subscriptions for the replication definitions at the remote sites.