First Guide to SQL Anywhere Studio
   PART 2. Getting Results with SQL Anywhere Studio
     CHAPTER 11. Replicating Data with SQL Remote       

Tutorial overview

This tutorial describes how to set up a simple SQL Remote replication system.

Data replication is the sharing of data between physically distinct databases. By sharing information they become a dispersed database 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.

For complete information about SQL Remote, see the book Data Replication with SQL Remote.

  Tutorial goals

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:

1. Setting up the consolidated database.

2. Creating a file-sharing replication system with a single remote database.

3. Replicating data between the two databases.

  To prepare for the tutorial:

1. Create a directory to hold the files you make during this tutorial; for example c:\tutorial.

   mkdir c:\tutorial

2. Create a subdirectory for each of the two user IDs in the replication system, to hold their messages. Create these subdirectories using the following statements at a system command line:

   mkdir c:\tutorial\dba
   mkdir c:\tutorial\field