There are two bulk materialization options for subscriptions
to primary data in a non-ASE database.
The options include:
- Atomic
bulk materialization
- 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 function
to activate the subscription using the with suspension option.
See the Replication Server Reference Manual > Replication Server System Functions > rs_marker for
information about applying this function.
- 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.
- Nonatomic
bulk materialization
- 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 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 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.