MobiLink Synchronization Wizard in SQL Anywhere 10
(Page 1 of 8 )
If you work with data that is distributed and stored in databases, then you understand the importance of keeping multiple databases synchronized. Mobilink is a technology that can help with that process. Keep reading to learn more.
Distributed Data and Synchronization
Data that is to be distributed and stored in databases typically requires a synchronization technology to manage the complexities of data distribution. Synchronization refers to how a process can achieve a single unified view of the distributed data within multiple databases. During a synchronization process two databases exchange changes made to the data in each database. Special rules can be defined to handle conflicts, such as when the same piece of data has been changed within both databases.
MobiLink is a synchronization technology where a multiplicity of remote databases can synchronize with a single consolidated database. This has a special attraction for "traveling salesman" type scenarios when the client starts synchronizing either to get the latest value/inventory information, or uploads some sales information. This is even more important when such data will be accessed from mobile devices which may connect to the main database only occasionally.
This tutorial is part 1 of a series focused on understanding how the MobiLink synchronization wizard is used to generate a MobiLink synchronization model. In part 2 of the series, deploying this model to a remote server running on a desktop computer using the Sybase Central Management tool will be described. For both parts the test arrangement has the following components:
Details of table used in synchronization using MobiLink
A step-by-step method of using the MobiLink Synchronization wizard will be described. For this purpose a table, Customers10 in the Test10 database on a Microsoft SQL 2005 Server, is chosen for synchronization. This is just one table from the Northwind database. The details of this table are shown in the next picture. This picture shows only part of the data in this table.
Next: Creating the data source for the MobiLink synchronization setup >>
More Database Code Articles
More By Jayaram Krishnaswamy
/ 8 
