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.
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: 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
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|