Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Concepts

Introducing SQL Remote Next Page

SQL Remote components

The following components are required for SQL Remote:

The architecture of a SQL Remote installation, showing the SQL Remote Message Agent, the data server, and the message system.
The data server

The data server must be a SQL Anywhere server.

Client applications

The client application can use ODBC, embedded SQL, or a variety of other programming interfaces.

See SQL Anywhere Data Access Programming Interfaces.

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.

Message Agent

The 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.

The Message Agent is a program called dbremote.exe on PC operating systems, and dbremote on Unix.

Schematic diagram of the components involved in SQL Remote replication.
Message system client

If you are using a shared file message system, no message system client is needed.

If you are using an email or other message system, you must have a message system for that client in order to send and receive messages.