SQL Statement Replication

Replication Server supports SQL statement replication in Adaptive Server which complements log-based replication and addresses performance degradation caused by batch jobs.

• Introduction to SQL Statement Replication
  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.
• Performance Issues with Log-Based Replication
  Address the performance issues caused by log-based replication.
• Enable SQL Statement Replication
  You can enable SQL statement replication at the database, table or session level. Session settings override both table and database settings. Table settings override database settings.
• Set SQL Statement Replication Threshold
  You can trigger SQL statement replication without having to set the threshold on individual tables.
• Configure Replication Definitions for SQL Statement Replication
  You can change SQL statement replication options at the database and table levels for replication definitions.
• Row Count Validation for SQL Statement Replication
  You can specify how Replication Server responds to SQLDML row count errors that may occur during SQL statement replication.
• Scope of SQL Statement Replication
  Learn how SQL statement replication applies to DML statements in batch processing, triggers, and stored procedures.
• Issues Resolved by SQL Statement Replication
  In some cases, data cannot be replicated using traditional replication methods. SQL statement replication provides a way to replicate data successfully in such situations .
• Exceptions to Using SQL Statement Replication
  There are several limitations to using SQL statement replication.
• RSSD System Table Modifications
  There are several changes to system tables in the Replication Server System Database (RSSD) to support SQL statement replication.
• Adaptive Server Monitoring Tables for SQL Statement Replication
  Use Adaptive Server monitoring tables to provide a statistical snapshot of the state of Adaptive Server during SQL statement replication. The tables allow you to analyze Adaptive Server and Adaptive Server performance.
• Product and Mixed-Version Requirements
  SQL statement replication requires Adaptive Server version 15.0.3 and later, primary and replicate Replication Server version 15.2 and later, and route version 15.2 and later.
• Downgrades and SQL Statement Replication
  Learn the downgrade procedures if you are using SQL statement replication and you wish to downgrade Adaptive Server to a version earlier than 15.0.2 ESD #3, or Replication Server to a version earlier than 15.2.