Contents Index Replicate from the remote database to the consolidated database A Tutorial for Adaptive Server Enterprise Users

SQL Remote User's Guide
  Tutorials for Adaptive Server Anywhere Users

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 tutorials, in more detail.

To add the publication to the sample database

  1. Connect to the sample database from Interactive SQL.

  2. In the SQL Statements pane, execute the following statement:

    READ path\scripts\salespub.sql

    where path is your SQL Anywhere 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 Index Replicate from the remote database to the consolidated database A Tutorial for Adaptive Server Enterprise Users