Contents IndexStart replicating data Some sample SQL Remote setups

User's Guide
   Part III. Using SQL Anywhere
     Chapter 27. Introduction to SQL Remote Replication
      A sample publication

The command file SALESPUB.SQL contains a set of statements that creates a publication on the sample database. This publication illustrates several of the points of the tutorial, in more detail.

To add the publication to the sample database:

  1. Connect to the sample database from ISQL.
  2. Type READpath\salespub.sql, where pathis your SQL Anywhere installation directory.

The SALESPUB.SQL publication adds columns to some of the tables in the sample database, creates a publication and subscriptions, and also adds triggers to resolve update conflicts that may occur.

Contents IndexStart replicating data Some sample SQL Remote setups