Replication Agent for SQL Anywhere

As a primary data server in a replication system, Replication Agent SQL Anywhere, packaged with the database, interacts with the Replication Agent. The Replication Agent for SQL Anywhere identifies and transfers transactions from the Replication Agent SQL Anywhere primary database to a primary Replication Server.

In Replication Agent for SQL Anywhere, all database object identifiers are case-insensitive (that is, uppercase and lowercase are treated as the same). In Adaptive Server Enterprise, database object identifiers are by, default, case-sensitive. With Replication Agent for SQL Anywhere, to ensure compatibility with ASE, verify that the case of database object identifiers matches in all parts of the SQL statements.

One of the differences between the Replication Agent for Adaptive Server Enterprise and the Replication Agent for SQL Anywhere is that while the ASE depends on a temporary recovery database to access old transactions, the SQL Anywhere Replication Agent accesses old transaction logs. No temporary recovery database exists for the Replication Agent for SQL Anywhere.