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
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|