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.
Created June 12, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com