You can create snapshot subscriptions in the Data Replicator that replicate data from a single source object to multiple destinations within the same DBMS, such as illustrated below. However, this may cause the data that is replicated to differ for each destination as each subscription reads the source data at a slightly different point in time. This method also concentrates the replication load at the source computer, where computing resources may already be in high demand.
A more reliable method of replicating data to multiple tables for the same type of destination is to create a Data Replicator snapshot subscription that replicates the data to one destination, and then use the replication facility within the DBMS to replicate the data to additional destinations. For example, you could use the Data Replicator to replicate data from a Db2 or Oracle source object to a SQL Server destination, and then use the SQL Server replication functions to replicate the data to additional SQL server destinations. This method ensures the same data is replicated to all destinations as they are all replicated from the same snapshot of the source data. This method also concentrates the replication load at the destination, rather than at the source, conserving those host resources for other uses.
