Materialization is creating and activating subscriptions, and copying data from the primary database to the replicate database, thereby initializing the replicate database.
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 character set. The replicate Replication Server 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.
Note:
In bulk materialization,
a subscription is initialized by a user-chosen mechanism outside
the replication system. Therefore, 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.