SQL Remote User's Guide
SQL Remote for Adaptive Server Enterprise and Adaptive Server Anywhere: Differences
The major differences in functionality between SQL Remote for Adaptive Server Enterprise (SRE) and SQL Remote for Adaptive Server Anywhere (SRA) are as follows:
Schema changes For SRE, schema changes must be made on a quiet system. A quiet system means the following:
No transactions being replicated There can be no transactions being replicated that modify the tables that are to be altered. All transactions that modified tables being altered must be scanned from the transaction log into the stable queue before the schema is altered. This is performed by running the Message Agent normally, or using the -i -b
options. After the Message Agent completes, you can make the schema change.
Message Agent shut down The Message Agent must be shut down when the schema change is being made.
SQL Remote Open Server If you are using the SQL Remote Open Server, it must be shut down when the schema change is being made.
Trigger action replication In SRE, trigger actions are replicated. In SRA you have the choice of replicating trigger actions, but by default they are not replicated. The replication of trigger actions requires SRE users to ensure that triggers are not fired at remote databases.
Platform availability SRA is available on a wider variety of platforms that SRE, reflecting the platform availability of the two servers.
Publication definitions Publications in SRA can be more selective than those in SRE. For example, in SRA you can use a WHERE clause with any value. In SRE, you can only use IS NULL and IS NOT NULL conditions in the WHERE clause.