Introducing SQL Anywhere Studio
Tutorial: Synchronizing Databases with MobiLink
Data replication is the sharing of data among physically distinct databases. Sybase provides three distinct technologies for data replication:
MobiLink
SQL Remote
Replication Server
MobiLink synchronization enables replication between an ODBC-compliant consolidated database and Adaptive Server Anywhere or UltraLite remote databases. In this tutorial an Adaptive Server Anywhere remote database is used. The consolidated database can be made by Sybase Adaptive Server Anywhere, Sybase Adaptive Server Enterprise, Oracle, Microsoft SQL Server, or IBM DB2.
MobiLink is designed for synchronization involving a consolidated data server and large numbers of remote databases, typically including many mobile databases. Administration and resource requirements at the remote sites are minimal. The system is connection-based and a remote site can connect as often as desired. At the end of each connection, the databases are fully synchronized.
MobiLink works by lumping the results of multiple transactions on the remote database into one set of changes applied to the consolidated database. Since synchronization always occurs at a transaction boundary, referential integrity is preserved. The order of the individual changes made during the component transactions is not preserved: since uncommitted data is never replicated, data integrity is preserved.
For more information about synchronization strategies, including complete MobiLink documentation, see the About This Manual.
For an introduction to SQL Remote synchronization, see Tutorial: Replicating Data with SQL Remote.