Filter
Top Products
Appendix A. SQL Remote for Adaptive Server Enterprise and
Adaptive Server Anywhere: Differences
Differences in functionality
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.
439