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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Replication » Replicating data with Replication Server


Using the LTM

Since the SQL Anywhere LTM relies on information in the SQL Anywhere transaction log, take care not to delete or damage the log without storing backups (for example, using a transaction log mirror).

For more information about transaction log management, see Transaction log and backup management.

You cannot substitute a SQL Anywhere LTM for an Adaptive Server Enterprise LTM since the transaction logs have different formats.

The SQL Anywhere LTM supports replication of inserts, updates, and deletes, and replication of Transact-SQL dialect stored procedure calls.

The Adaptive Server Enterprise LTM sends data changes to the Replication Server before they are committed. The Replication Server holds the changes until a COMMIT statement arrives. By contrast, the SQL Anywhere LTM sends only committed changes to Replication Server. For long transactions, this may lead to some added delay in replication, since all changes have to go through the Replication Server before distribution.

Configuring tables for replication
Preparing procedures and functions for replication
SQL statements for controlling procedure replication
Asynchronous procedures
Configuring the LTM
Language and character set issues
Transaction log and backup management
Replicating an entire database
Stopping the LTM