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