MobiLink Contact sample

The Contact sample is a valuable resource for the MobiLink developer. It provides you with an example of how to implement many of the techniques you need to develop MobiLink applications.

The Contact sample application includes a SQL Anywhere consolidated database and two SQL Anywhere remote databases. It illustrates several common synchronization techniques. To get the most out of this section, study the sample application as you read.

Although the consolidated database is a SQL Anywhere database, the synchronization scripts consist of SQL statements that should work with minimal changes on other database management systems.

The Contact sample is in %SQLANYSAMP12%\MobiLink\Contact.

Synchronization design

The synchronization design in the Contact sample application uses the following features:

Column subsets A subset of the columns of the Customer, Product, SalesRep, and Contact tables on the consolidated database are shared with the remote databases.
Row subsets All the columns, but only one of the rows of the SalesRep table on the consolidated database are shared with each remote database. See Partitioning rows among remote databases.
Timestamp-based synchronization This is a way of identifying changes that were made to the consolidated database since the last time a device synchronized. The Customer, Contact, and Product tables are synchronized using a method based on timestamps. See Implementing timestamp-based downloads.

Contact sample setup
Tables in the Contact databases
Users in the Contact sample
Synchronization of sales representatives in the Contact sample
Synchronization of customers in the Contact sample
Synchronization of contacts in the Contact sample
Synchronization of products in the Contact sample
Statistic and error monitoring in the Contact sample

Discuss this page in DocCommentXchange.