Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere 11 - Introduction » Working with Databases » Overview of data exchange technologies » Comparing synchronization technologies » Benefits of data synchronization » Propagation methods


Connection-based synchronization

Some synchronization technologies rely on the presence of a continuous, or at least almost continuous, connection between the databases. Through this connection, the two databases conduct an ongoing dialog. These types of systems excel at replicating changes quickly. Given sufficient resources and channel capacity, synchronization can occur reliably with a lag time of no more than a few seconds.

The main drawback of this type of system is that a reliable, continuous connection can be expensive to maintain. This restriction makes connection-based technologies suited to replication between two large, fixed databases. In environments where the remote computers are mobile or are only occasionally connected, session-based (MobiLink) or message-based (SQL Remote) technologies provide more flexible solutions.

To create a connection-based synchronization system with SQL Anywhere, you need to use Sybase Replication Server. See Replicating data with Replication Server.