SQL Remote User's Guide
SQL Remote Concepts
The following components are required for SQL Remote:
Data server An Adaptive Server Anywhere or Adaptive Server Enterprise database-management system is required at each site to maintain the data.
Message Agent A SQL Remote Message Agent is required at the consolidated site and at each remote site to send and receive SQL Remote messages.
The Message Agent connects to the data server by a client/server connection. It may run on the same machine as the data server or on a different machine.
Database extraction utility The extraction utility is used to prepare remote databases from a consolidated database, during development and testing, and also at deployment time.
Message system client software SQL Remote uses existing message systems to transport replication messages. A file-sharing "message system" is provided, which does not require client software. Each computer involved in SQL Remote replication using a message system other than file sharing must have that message system installed.
Client applications The applications that work with SQL Remote databases are standard client/server database applications.
The data server
Client applications
The Message Agent
Message system client