SQL Remote message systems

In SQL Remote replication, a message system is a protocol for exchanging messages between the consolidated database and a remote database. 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.

  • FTP   Internet file transfer protocol.

  • HTTP   Hypertext transfer protocol.

  • SMTP/POP   Internet email protocol.

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

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.

 Setting up a message system
 Extraction utility (dbxtract)
 See also

Creating message types
Alter message types
Deleting message types
Setting remote message type control parameters
The FILE message system
The FTP message system
The HTTP message system
The SMTP message system