Introducing SQL Anywhere Studio
Replication Technologies
Sybase replication technologies
Choosing a replication technology
SQL Remote is designed for replication installations with the following requirements:
Large numbers of 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 on which the server is running.
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 installation. With SQL Remote, replication messages are sent typically 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 Adaptive Server Enterprise and Adaptive Server Anywhere databases. Each database in the system must have a very similar schema.