Introduction
Thischapter presents a tutorial to lead you through setting up a SQL Remote
installation. The installation replicates data between an Adaptive Server
Enterprisedatabase (the consolidated database) and an Adaptive Server
Anywheredatabase (the remote database).
Goals
Inthe tutorial you act as the system administratorof a consolidated Adaptive
ServerEnterprise database, and set up a simple replication system. The
replicationsystem 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.
Thetutorial takes you through the following steps:
♦Creatinga consolidated database on your Adaptive Server Enterprise
server.
♦Creatinga file-sharing replication system with a single Adaptive Server
Anywhereremote database.
♦Replicatingdata between the two databases.
The database
Thetutorial uses 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 tutorial 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
54