SQL Remote User's Guide
Tutorials for Adaptive Server Anywhere Users
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. 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 Tutorial: Managing Databases with Sybase Central.
Preparing for the Sybase Central replication tutorial
Setting up a consolidated database
Set up the remote database in Sybase Central