Tutorial: Adaptive Server Anywhere replicationusing Sybase Central
Thefollowing sections are a tutorial describing how to set up a simple
SQLRemote replication system in Adaptive Server Anywhere using Sybase
Central.
Youdo not need to enter SQL statements if you are using Sybase Central to
administerSQL Remote. Atutorial for those who do not have access to
SybaseCentral, or who prefer to work with command-line utilities, is
presentedin “Tutorial: AdaptiveServer Anywhere replication using
InteractiveSQL and dbxtract” on page 40. Thistutorial contains the SQL
statementsexecuted behind the scenes by Sybase Central.
Inthis tutorial you act as the DBA of the consolidated database, and set up a
simplereplication system using the file-sharing message link. Thesimple
exampleis 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
databaseand one remote database. Youcan install this example on one
computer.
Thistutorial assumes that you have some familiarity with Sybase Central.
☞Foran introduction to Sybase Central, see “ Managing Databases with
SybaseCentral” [Introducing SQL Anywhere Studio, page 241].

Preparing for the Sybase Central replication tutorial

Thissection describes the steps you need to take to prepare for the tutorial.
Thesesteps include the following:
♦Createthe directories and databases required for the tutorial.
♦Addthe tables to the consolidated database.
❖Toprepare 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. Createthese subdirectories using the
followingstatements at a system command line:
32