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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere 11 - Introduction » SQL Anywhere 11 Overview » Overview of data exchange technologies » Comparing synchronization technologies » 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 enough 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.