Contents Index Character set and language issues Configuring tables for replication

ASA Database Administration Guide
  Replicating Data with Replication Server

Using the LTM


Since the Adaptive Server Anywhere LTM relies on information in the Adaptive Server 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 the section Transaction log and backup management.

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

The Adaptive Server Anywhere LTM supports replication of inserts, updates, and deletes, as well as 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 Adaptive Server 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

Contents Index Character set and language issues Configuring tables for replication