- Introduction
- Sybase SQL Anywhere Studio 8.0
- Relational Databases
- Synchronization Tools
- Administration/Development Tools
- Conclusion
Synchronization Tools
SQL Anywhere Studio supports two primary data synchronization/replication options. The first option, Mobilink, involves the use of a middle-tier synchronization server product that runs on either Windows 2000/XP or Solaris. The Mobilink accepts incoming requests from ASA or Ultralite clients and routes these synchronization requests to the appropriate "consolidated" database via threaded ODBC connections. In addition to client-side development tasks, the SQL Anywhere Studio developer can also fine-tune synchronization from the client to the server (and vice versa) through the development of SQL-based upload/download synchronization scripts. These scripts are actually stored in the back-end database server (which could be Sybase, SQL Server, Oracle, or DB2) and are run for each synchronized database table as well as for "global" synchronization events (begin, end, and so on). For clients synchronizing only with the Sybase Adaptive Server Anywhere or Adaptive Server Enterprise databases, the SQL Remote two-way, message-based replication option is also offered. SQL Remote is fully supported only on Windows 95/98/NT, but is partially supported on Windows CE.