Sybase DC38133-01-0902-01 manual Differences in functionality

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-boptions. After the Message Agent completes, you can make the schema change.

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:

∙

∙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