Replication Server 15.2 supports SQL statement replication which complements log-based replication and addresses performance degradation caused by batch jobs.
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. 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 SQL statement replication:
Configure the primary database to log SQLDML.
Configure Replication Server to replicate SQLDML:
Create replications definitions with SQLDML for table and multisite availability (MSA) replication.
In Replication Server, set WS_SQLDML_REPLICATION parameter on for warm standby replication.
See the Adaptive Server 15.0.3 New Features Guide for more information on SQL statement replication.
