Sybase recommends that you use bulk materialization to materialize subscriptions to primary data in a non-Sybase database. When you use bulk materialization, you must coordinate and manually perform the following materialization activities:
Define, activate, and validate the subscription (or create the subscription without materialization).
Unload the subscription data at the primary site.
Move the unloaded data to the replicate database.
Load data into the replicate tables.
Resume the database connection from the replicate Replication Server to the replicate database so that the replicate database can receive replicated transactions.
Resume replication at the Replication Agent instance.
There are two bulk materialization options for subscriptions to primary data in a non-Sybase database:
Atomic bulk materialization
Nonatomic bulk materialization
The atomic bulk materialization procedure consists of the following tasks:
Stop updates to the primary table and dump the subscription data from the primary database.
In the replicate Replication Server, define the subscription
In the primary database, use the rs_marker stored procedure or invoke the Replication Agent ra_marker command to activate the subscription using the with suspension option.
Load the subscription data into the replicate table.
Resume the database connection from the replicate Replication Server to the replicate database.
In the replicate Replication Server, validate the subscription.
For a complete step-by-step atomic bulk materialization
procedure, see “Atomic bulk materialization procedure”.
The nonatomic bulk materialization procedure consists of the following tasks:
In the replicate Replication Server, use the set autocorrection command.
In the replicate Replication Server, define the subscription.
In the primary database, use the rs_marker stored procedure or invoke the Replication Agent ra_marker command to activate the subscription using the with suspension option.
Dump the subscription data from the primary database.
In the primary database, use the rs_marker stored procedure or invoke the Replication Agent ra_marker command to validate the subscription.
Load the subscription data into the replicate table.
Resume the database connection from the replicate Replication Server to the replicate database.
When the subscription becomes valid at all Replication Servers, turn off autocorrection.
For a complete step-by-step nonatomic bulk materialization
procedure, see “Nonatomic bulk materialization procedure”.
