Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Remote


Tutorial: Setting up a replication system using the HTTP message system

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.

  • Create a message server SQL Anywhere database to act as a web server to receive messages from the remote database using the HTTP protocol.

  • Replicate data between the consolidated and remote databases.

Role requirement

This tutorial refers to a user, DBA, that must have the SYS_REPLICATION_ADMIN_ROLE system role.

Lesson 1: Creating the consolidated database
Lesson 2: Creating 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