Sybase SQL Remote DC38133-01-0902-01 User Manual
The office server may be running a server to manage the company database.
The Message Agent at the company database runs as a client application for
that server.
The Message Agent at the company database runs as a client application for
that server.
At the laptop computers each sales representative has an Adaptive Server
Anywhere personal server to manage their own data.
Anywhere personal server to manage their own data.
While away from the office, a sales representative can make a single phone
call from their laptop to carry out the following functions:
call from their laptop to carry out the following functions:
♦
Collect new e-mail.
♦
Send any e-mail messages they have written.
♦
Collect publication updates from the office server.
♦
Submit any local updates, such as new orders, to the office server.
The updates may include, for example, new specials on the products the
sales representative handles, or new pricing and inventory information.
These are read by the Message Agent on the laptop and applied to the sales
rep’s database automatically, without requiring any additional action on the
sales representative’s part.
sales representative handles, or new pricing and inventory information.
These are read by the Message Agent on the laptop and applied to the sales
rep’s database automatically, without requiring any additional action on the
sales representative’s part.
The new orders recorded by the sales representative are also automatically
submitted to the office without any extra action on the part of the sales
representative.
submitted to the office without any extra action on the part of the sales
representative.
Server-to-server replication among offices
SQL Remote provides two-way replication between database servers at sales
offices or outlets and a central company office, without requiring database
administration experience at each sales office beyond the initial setup and
that required to maintain the server.
offices or outlets and a central company office, without requiring database
administration experience at each sales office beyond the initial setup and
that required to maintain the server.
SQL Remote 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
hour or so.
site. Instead, it is appropriate where data can be replicated at periods of an
hour or so.
Such a setup may use an e-mail system to carry the replication, if there is
already a company-wide e-mail system. Alternatively, an occasional dial-up
system and file transfer software can be used to implement a FILE message
system.
already a company-wide e-mail system. Alternatively, an occasional dial-up
system and file transfer software can be used to implement a FILE message
system.
16