Tutorial: Setting up a replication system using the HTTP message system and the consolidated database as the message server via Relay Server

Use the lessons in this tutorial to learn how to set up a SQL Remote replication system that uses a SQL Anywhere consolidated database, Relay Server to forward HTTP traffic to the consolidated database, and a remote database. The consolidated database uses the FILE message system to replicate changes, while the remote database uses the HTTP message system to replicate changes.

In this tutorial you:

  • Create a consolidated SQL Anywhere database and a remote SQL Anywhere database that contains all the data in the consolidated database.

  • Create a directory structure to store the messages generated by SQL Remote. The consolidated database accesses the files using the FILE message system, while the remote database uses the HTTP message system.

  • Configure an existing Relay Server to forward HTTP traffic to the consolidated database.

  • Configure the consolidated database to act as the message server for the HTTP message system and accept forwarded HTTP traffic from the Relay Server.

  • Create a remote database that sends messages using the HTTP messaging system.

  • Replicate data between the consolidated and remote databases.


Lesson 1: Creating the consolidated database
Lesson 2: Configuring the Relay Server
Lesson 3: Configuring the consolidated database to act as the message server
Lesson 4: Creating the remote database
Lesson 5: Adding and replicating data in the consolidated and remote databases
Lesson 6: Cleaning up