SQL Remote message systems

SQL Remote exchanges data among databases using one or more underlying message systems. SQL Remote supports the following message systems:

File sharing A simple system requiring no extra software. See The FILE message system.
FTP Internet file transfer protocol. See The FTP message system.
SMTP/POP Internet email protocol. See The SMTP message system.

You choose a message system when you assign REMOTE or CONSOLIDATE permission to a user. See Grant REMOTE permission and Grant CONSOLIDATE permission.

Each message system that is used in a SQL Remote system has control parameters and other settings that must be set up.

Not all message systems are supported on all operating systems. For a complete list of supported operating systems, see Supported platforms.

Setting up a message system

Before you can use a message system, you must set the publisher's address.

Each message type definition includes the message system type name (FILE, FTP, or SMTP) and the address of the publisher under that message type.

The address supplied with a message type definition is closely tied to the publisher ID of the database.

Extraction utility (dbxtract)

The publisher address at a consolidated database is used by the Extraction utility (dbxtract) and the Extract Database Wizard as a return address when creating remote databases. It is also used by the Message Agent (dbremote) to identify the location of incoming messages for the FILE system.