Tutorial: Creating a SQL Remote 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 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