Overview

In SQL statement replication, Replication Server receives the SQL statement that modified the primary data, rather than the individual row changes from the transaction log. Replication Server applies the SQL statement to the replicated site. The Adaptive Server RepAgent sends both the SQL data manipulation language (DML) and individual row changes. Depending on your configuration, Replication Server chooses either individual row change log replication or SQL statement replication.

SQL statement replication includes row count verification to ensure that the number of rows changed in the primary and replicate databases match after replication. If the number of rows do not match, you can specify how Replication Server handles this error.

To enable and configure SQL statement replication:

• Configure the primary database to log SQLDML.

• Configure Replication Server to replicate SQLDML:

  1. Create replications definitions with SQLDML for table and multisite availability (MSA) replication.

  2. In Replication Server, set WS_SQLDML_REPLICATION parameter on for warm standby replication.