Collection Contents Index Start replicating data CHAPTER 5.  A Tutorial for Adaptive Server Enterprise Users pdf/chap4.pdf

Data Replication with SQL Remote
   PART 1. Introduction to SQL Remote
     CHAPTER 4. A Tutorial 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 tutorial, in more detail.

  To add the publication to the sample database:
  1. Connect to the sample database from Interactive SQL.

  2. Type READ path\scripts\salespub.SQL, where path is your Adaptive Server 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.


Collection Contents Index Start replicating data CHAPTER 5.  A Tutorial for Adaptive Server Enterprise Users pdf/chap4.pdf