Materializing Subscriptions to Primary Data

Learn about bulk materialization, the process of materializing subscriptions to primary tables in a non-Sybase database, and how to use bulk materialization to set up replication from primary tables in a primary database.

• Materialization
  Materialization is the creation and activation of subscriptions and the copying of data from the primary database to the replicate database, thereby initializing the replicate database.
• Data Unloading and Loading
  Part of subscription materialization is unloading subscription data from the primary table so it can be loaded into the replicate table.
• Atomic Bulk Materialization
  Atomic bulk materialization assumes that all applications updating the primary table can be suspended while a copy of the table is made. This copy is loaded at the replicate site.
• Nonatomic Bulk Materialization
  Nonatomic bulk materialization assumes applications updating the primary table cannot be suspended while a copy of the table is made. Therefore, a nonatomic materialization requires the use of the Replication Server autocorrection feature to get the replicate database synchronized with the primary database.