Tutorial: Setting up a replication system using the HTTP message system with the consolidated database as the message server

Use the lessons in this tutorial to learn how to set up a SQL Remote replication system that uses both a SQL Anywhere 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 the consolidated database to act as the message server for the HTTP message system.

  • 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 consolidated database to act as the message server
Lesson 3: Creating the remote database
Lesson 4: Adding and replicating data in the consolidated and remote databases
Lesson 5: Cleaning up