Figure 7-1 illustrates the typical message flow during subscription materialization.
Figure 7-1: Subscription materialization
During subscription materialization:
The replicate Replication Server logs in to the primary data server and issues a select statement to retrieve the primary data.
The primary data server converts all character data to the replicate Replication Server’s character set. The replicate Replication Server’s character set, if it is different, must be installed at the primary data server.
The replicate Replication Server inserts the data at the replicate data server.
In bulk materialization,
a subscription is initialized by a user-chosen mechanism outside
the replication system. Therefore, you must make sure that the initial
data selection at the primary data server uses the correct sort
order and that the character data is converted to the replicate
data server character set, if need be.
