Chapter 2. SQL Remote Concepts
Some sample installationsWhileSQL Remote can provide replication services in many different
environments,its features are designed with the following characteristics in
mind:
♦SQLRemote should be a solution even when no administration load can
beassigned to the remote databases, as in mobile workforce applications.
♦Datacommunication among the sites may be occasional and indirect: it
neednot be permanent and direct.
♦Memoryand resource requirements at remote sites are assumed to be at a
premium.
Thefollowing examples show some typical SQL Remote setups.
Server-to-laptop replication for mobile workforces
SQLRemote provides two-way replication between a database on an office
networkand personal databases on the laptop computers of sales
representatives. Such a setup may use an e-mail system as a message
transport.
Laptop computer
Remote
database
Laptop computer
Remote
database
Office network
server
Consolidated
database
Laptop computer
Remote
database
Laptop computer
Remote
database
15