Sybase DC38133-01-0902-01 manual Preparing for the Sybase Central replication tutorial

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:ntutorial

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