SQL Remote is designed for synchronization systems with the following requirements:
Large numbers of remote databases SQL Remote is designed to support a large number of remote databases. It can support thousands of remote databases in a single installation because the messages for many remote sites can be prepared simultaneously.
Occasionally connected SQL Remote supports databases that are occasionally connected or indirectly connected to the network.
Low to high latency High latency means a long lag time between data being entered at one database and being replicated to each database in the system. With SQL Remote, replication messages can be sent at periods of seconds, minutes, hours, or days.
Low to moderate volume As replication messages are delivered occasionally, a high transaction volume at each remote site can lead to a very large volume of messages. SQL Remote is best suited to systems with a relatively low volume of replicated data per remote database. At the consolidated site, SQL Remote can, however, prepare messages efficiently by preparing messages for multiple sites simultaneously.
Homogeneous databases SQL Remote supports SQL Anywhere databases. Each database in the system must have a similar schema.