User's Manual

Tutorial: Adaptive Server Anywhere replication
using Sybase Central
The following sections are a tutorial describing how to set up a simple
SQL Remote replication system in Adaptive Server Anywhere using Sybase
Central.
You do not need to enter SQL statements if you are using Sybase Central to
administer SQL Remote. A tutorial for those who do not have access to
Sybase Central, or who prefer to work with command-line utilities, is
presented in “Tutorial: Adaptive Server Anywhere replication using
Interactive SQL and dbxtract” on page 40. This tutorial contains the SQL
statements executed behind the scenes by Sybase Central.
In this tutorial you act as the DBA of the consolidated database, and set up a
simple replication system using the file-sharing message link. The simple
example is a primitive model for a sales-force automation system, with two
tables. One contains a list of sales representatives, and another a list of
customers. The tables are replicated in a setup with one consolidated
database and one remote database. You can install this example on one
computer.
This tutorial assumes that you have some familiarity with Sybase Central.
☞ For an introduction to Sybase Central, see “ Managing Databases with
Sybase Central” [Introducing SQL Anywhere Studio, page 241].
Preparing for the Sybase Central replication tutorial
This section describes the steps you need to take to prepare for the tutorial.
These steps include the following:
♦ Create the directories and databases required for the tutorial.
♦ Add the tables to the consolidated database.
❖ 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:
32