Start replicating data
Younow have a replication system in place. In this section, data is replicated
fromthe consolidated database to the remote database, and from the remote
tothe consolidated database.

Enter data at the consolidated database

Inthis section we enter data into the SalesRep and Customer tables at the
consolidated(Adaptive Server Enterprise) database, and replicate this data to
theAdaptive Server Anywhere database.
❖Toenter data at the Adaptive Server Enterprise database
1. Connectto the AdaptiveServer 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
OceanSports isassigned to FieldUser, and SportsPlus isassigned to
AnotherUser. Youmust commit the changes, as SQL Remote replicates
onlycommitted changes.
Havingentered the data at the consolidated database, you now need to send
therelevant rows to the remote Adaptive Server Anywhere database.

Send data from the consolidated database

Tosend the rows to the remote database, you must run the Message Agent at
theconsolidated database. The
ssremote
programis the Message Agent for
AdaptiveServer Enterprise.
66