Use the lessons in this tutorial to learn how to set up a SQL Remote replication system that uses both a SQL Anywhere consolidated and remote database.
In this tutorial you:
Create a consolidated SQL Anywhere database and a remote SQL Anywhere database that contains a subset of the data in the consolidated database.
Create a file-sharing replication system with the single SQL Anywhere remote database.
Replicate data between the consolidated and remote databases.
Lesson 1: Creating the consolidated database
Lesson 2: Granting PUBLISH and REMOTE permissions at the consolidated database
Lesson 3: Creating publications and subscriptions
Lesson 4: Creating a SQL Remote message type
Lesson 5: Extracting the remote database
Lesson 6: Sending data from the consolidated database to the remote database
Lesson 7: Receiving data at the remote database
Lesson 8: Sending data from the remote database to the consolidated database
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|