Introducing SQL Anywhere Studio
Tutorial: Replicating Data with SQL Remote
This tutorial describes how to set up a simple SQL Remote replication system.
With SQL Remote, you can carry out two-way replication between a central database (called the consolidated database) and a set of remote databases. These remote databases may be on laptop computers, while the consolidated database may be on a network in an office. All the setup and administration is carried out at the consolidated database.
This tutorial describes a very simple case, replicating one table from the sample database to a single remote database on the same machine.
In the tutorial, you act as the system administrator of a consolidated Adaptive Server Anywhere database. The replication system consists of a simple table from the sample database. The table we replicate is the department table, which is one of the simplest in the database.
The tutorial takes you through the following steps:
Setting up the consolidated database.
Creating a file-sharing replication system with a single remote database.
Replicating data between the two databases.
Create directories for the tutorial