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.
  • Database server   A SQL Anywhere database is required at the consolidated site and each remote site.

  • SQL Remote   To send and receive replication messages from database to database, SQL Remote must be installed at the consolidated site and the remote sites.

    The SQL Remote Message Agent connects to the database server via a client/server connection. The SQL Remote Message Agent may run on the same computer as the database server or on a different computer.

  • Message system client software   SQL Remote uses existing message systems to transport replication messages.

    If you are using a shared file or FTP message system, the message system is included with your operating system.

    If you are using an SMTP email system, you must have an email client installed at the consolidated site and each remote site.

  • Client applications   The client application can use ODBC, embedded SQL, or several other 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. For specific details about the SQL Anywhere programming interfaces, see the list below: