Theoffice server may be running a server to manage the company database.
TheMessage Agent at the company database runs as a client application for
thatserver.
Atthe laptop computers each sales representative has an Adaptive Server
Anywherepersonal server to manage their own data.
Whileaway from the office, a sales representative can make a single phone
callfrom their laptop to carry out the following functions:
♦Collectnew e-mail.
♦Sendany e-mail messages they have written.
♦Collectpublication updates from the office server.
♦Submitany local updates, such as new orders, to the office server.
Theupdates may include, for example, new specials on the products the
salesrepresentative handles, or new pricing and inventory information.
Theseare read by the Message Agent on the laptop and applied to the sales
rep’sdatabase automatically, without requiring any additional action on the
salesrepresentative’s part.
Thenew orders recorded by the sales representative are also automatically
submittedto the office without any extra action on the part of the sales
representative.
Server-to-server replication among offices
SQLRemote provides two-way replication between database servers at sales
officesor outlets and a central company office, without requiring database
administrationexperience at each sales office beyond the initial setup and
thatrequired to maintain the server.
SQLRemote is not designed for up-to-the-minute data availability at each
site. Instead, it is appropriate where data can be replicated at periods of an
houror so.
Sucha setup may use an e-mail system to carry the replication, if there is
alreadya company-wide e-mail system. Alternatively,an occasional dial-up
systemand file transfer software can be used to implement a FILE message
system.
16