The bulk materialization method involves manually transferring subscription data between databases. Use this method when a subscription is too large to copy through the network.
Use define subscription to add the subscription to the Replication Server System Database (RSSD) for the primary and replicate Replication Servers.
After the subscription is defined, use activate subscription to set the subscription status to Activating at the replicate Replication Server and to send the activation request to the primary Replication Server.
When the primary Replication Server receives the activation request, it changes the subscription status to Active, sends the activation request back to the replicate Replication Server, and begins sending updates for the subscription to the replicate Replication Server. When the replicate Replication Server receives the activation request, it changes the subscription status to Active at the replicate Replication Server.
If the with suspension option was specified for the activate subscription command, the Data Server Interface (DSI) thread is suspended when the activation request is received at the replicate Replication Server. At this stage, you load the replicate database. For more information, see the Replication Server Reference Manual. After loading, execute the resume connection command to continue applying transactions from the DSI.
After the subscription is activated, use validate subscription to verify that the data at the replicate data is consistent with the primary data at the replicate Replication Server and to complete bulk materialization. The subscription status is changed to Validating. The replicate Replication Server forwards the validation request to the primary Replication Server.
When the primary Replication Server receives the validation request, it changes the status at the primary to Valid and returns the validation request to the replicate Replication Server. When the replicate Replication Server receives the validation request, the subscription status becomes Valid at both sites, and the bulk materialization is complete.