Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Remote » Creating SQL Remote systems

 

Understanding transaction log-based replication

SQL Remote replicates:

  • Committed changes   Changes that have been made to databases as recorded in their transaction log.

  • Changes that modify data that belong to publications   SQL Remote scans the transaction log for committed changes to rows that belong to publications, packages the SQL statements into messages, and sends them to the subscribed databases.

On the consolidated database, all committed transactions in the transaction log that belong to publications are sent periodically to the remote databases.

On the remote databases, all committed transactions in the transaction log that belong to publications are sent periodically to the consolidated database.

The SQL Remote publish and subscribe model. The remote and consolidated databases each subscribe to the other's publications.
 The database server handles publications
 Subscriptions are handled by SQL Remote
 See also

Replicating INSERT and DELETE statements
Replicating UPDATE statements
Replicating procedures
Replicating triggers
Data definition statements
Data types