Data Replication with SQL Remote
PART 1. Introduction to SQL Remote
CHAPTER 2. SQL Remote Replication 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 Each computer involved in a setup must have a message system client installed. SQL Remote does support a file-sharing "message system", which does not require client software in addition to the SMTP/POP, MAPI, and VIM message systems under some operating systems.
Client applications The applications that work with SQL Remote databases are standard client/server database applications.
The data serverThe data server may be an Adaptive Server Enterprise or an Adaptive Server Anywhere server. At the remote site the data server is commonly an Adaptive Server Anywhere personal server, but can also be an Adaptive Server Enterprise or Adaptive Server Anywhere server.
Client applicationsClient applications work with the data in the database. Client applications use one of the client/server interfaces supported by the data server:
For Adaptive Server Anywhere, the client application may use ODBC, Embedded SQL, or Sybase Open Client to work with Adaptive Server Anywhere.
For Adaptive Server Enterprise, the client application may use one of the Sybase Client Server interfaces, ODBC, or Embedded SQL.
Client applications do not have to know if they are using a consolidated or remote database. From the client application perspective, there is no difference.
The Message AgentThe SQL Remote Message Agent sends and receives replication messages. It is a client application that sends and receives messages from database to database. The Message Agent must be installed at both the consolidated and at the remote sites.
For Adaptive Server Anywhere, the Message Agent is a program called dbremote.exe on PC operating systems, and dbremote on UNIX.
For Adaptive Server Enterprise, the Message Agent is a program called ssremote.exe on PC operating systems, and ssremote on UNIX.
Message system clientIf you are using a shared file message system, no message system client is needed.
If you are using an e-mail or other message system, you must have a message system for that client in order to send and receive messages.