SQL Statement Replication

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.

See the Adaptive Server 15.0.3 New Features Guide for more information on SQL statement replication.

• Enabling SQL Statement Replication
  Configure Replication Server and the primary database to replicate SQL statements.
• Modifications to System Configuration
  Several Adaptive Server stored procedures support SQL statement replication.
• SQL Statement Replication Configuration
  You can change replication options at database and table levels.
• Row Count Validation for SQL Statement Replication
  In Replication Server 15.2, you can specify how Replication Server responds to SQLDML row count errors that may occur during SQL statement replication.
• Warm Standby Database Configuration for SQL Replication
  By default, warm standby applications do not replicate the DML commands that support SQL statement replication. You need to perform extra configuration to use SQL replication.
• Configuring Warm Standby Database for SQL Replication
  By default, warm standby applications do not replicate the DML commands that support SQL statement replication. You need to perform extra configuration to use SQL replication.
• Replication Server System Database Modifications
  The rs_dbreps, rs_dbsubsets, and rs_objects system tables in the Replication Server System Database (RSSD) have been modified to support SQL statement replication.