Sybase DC38133-01-0902-01 manual To enter data at the Adaptive Server Enterprise database

Start replicating data

You now have a replication system in place. In this section, data is replicated from the consolidated database to the remote database, and from the remote to the consolidated database.

Enter data at the consolidated database

In this section we enter data into the SalesRep and Customer tables at the consolidated (Adaptive Server Enterprise) database, and replicate this data to the Adaptive Server Anywhere database.

❖To enter data at the Adaptive Server Enterprise database

1. Connect to the Adaptive Server Enterprise server from isql :

isql -S server-name -U sa -P sysadmin

2. Ensure you are using the hq database, and enter a series of rows:

use hq go

insert into SalesRep (rep_key, name) values (’rep1’, ’Field User’)

go

insert into SalesRep (rep_key, name) values (’rep2’, ’Another User’)

go

insert into Customer (cust_key, name, rep_key) values (’cust1’, ’Ocean Sports’, ’rep1’)

go

insert into Customer (cust_key, name, rep_key) values (’cust2’, ’Sports Plus’, ’rep2’)

go commit go

Ocean Sports is assigned to Field User, and Sports Plus is assigned to Another User. You must commit the changes, as SQL Remote replicates only committed changes.

Having entered the data at the consolidated database, you now need to send the relevant rows to the remote Adaptive Server Anywhere database.

Send data from the consolidated database

To send the rows to the remote database, you must run the Message Agent at the consolidated database. The ssremote program is the Message Agent for Adaptive Server Enterprise.

66