Primary-Target Data Dissemination

Data dissemination supports business needs where data is updated in a central location and then replicated to servers that only receive data and do not update data.

This method of distribution can be useful for online transaction processing (OLTP) systems where data is required at several sites, but because of the large amounts of data, read/write capabilities at all sites would slow the performance of the application. The following figure illustrates data dissemination.
Figure 1: Data Dissemination in a Primary-Target Replication System

A single primary server sends data to four target servers that only receive data.

You specify that a server only receives information when you define the participant for the server as part of the replicate definition. You can specify that all replicates on a server only receive information when you modify the server definition.