User's Manual

Chapter 13. Using SQL Remote with Replication Server
Architecture for Replication Server/SQL Remote
installations
The arrangement for using a database as a Replication Server primary site
and as a SQL Remote database is illustrated in the following diagram. The
diagram illustrates a case where the stable queue is held in a different
database from the data being replicated. The stable queue may alternatively
be held in the same database as the data being replicated. All connections
are client/server connections, and so the components may be running on the
same or different machines.
SQL Remote
Open Server
SQL
Remote
Open
Server
Adaptive
Server
Enterprise
Replication
Agent
Replication
Server
SQL Remote
Message
Agent
To remote
databases
Stable
Queue
How the pieces fit together
The SQL Remote Open Server acts as a replicate database in the Replication
Server setup, and so replication definitions and subscriptions are required in
the Adaptive Server Enterprise database on all tables participating in
SQL Remote replication and on several of the SQL Remote system tables.
Contents of the stable
queue
All operations are replicated to the SQL Remote Open Server, which stores
them in the stable queue. The stable queue does not have copies of the tables
being replicated. It parses the inserts, updates, and deletes to build
transactions. All transactions are stored in an image column of a single
279