IntroductionThesetutorials describe how to set up a simple SQL Remote replication
systemusing AdaptiveServer Anywhere.
Goals
Inthe tutorials, you act as the system administrator of a consolidated
AdaptiveServer Anywhere database, and set up a simple replication system.
Thereplication system consists of a simple sales database, with two tables.
Theconsolidated database holds all of the database, while the remote
databasehas all of one table, but only some of the rows in the other table.
Thetutorials take you through the following steps:
♦Creatinga consolidated database on your Adaptive Server Anywhere
server.
♦Creatinga file-sharing replication system with a single Adaptive Server
Anywhereremote database.
♦Replicatingdata between the two databases.
The database
Thetutorials use a simple two-table database. One table holds information
aboutsales representatives, and the other about customers. The tables are
muchsimpler than you would use in a real database; this allows us to focus
juston those issues important for replication.
Databaseschema Thedatabase schema for the tutorials is illustrated in the figure.
rep_key =
rep_key
SalesRep
rep_key char(5)
name char(40)
Customer
cust_key char(10)
name char(40)
rep_key char(5)
Featuresto note include the following:
♦Eachsales representative is represented by one row in the SalesRep table.
♦Eachcustomer is represented by one row in the Customer table.
♦Eachcustomer is assigned to a single sales representative, and this
assignmentis built in to the database as a foreign key from the Customer
tableto the SalesReptable. The relationship between the Customer table
andthe SalesRep table is many-to-one.
28