SQL Remote characteristics

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.