MobiLink Synchronization Wizard in SQL Anywhere 10 - MobiLink Synchronization Wizard
(Page 3 of 8 )
Create Synchronization Model Wizard is a step-by-step, form-based wizard that helps you define a synchronization model. The model defines the tables and columns that need to be synchronized between a server and a plurality of remote databases on the client computers. It also sets up the various options for the synchronization. The model helps in the mapping between the consolidated database schema and the remote database schema and also the download/upload options for the synchronization process. After the model is created it is deployed to the consolidated and remote databases. Deployment creates the scripts and files needed during synchronization. Deployment will be described in part 2 of this tutorial series.
You invoke the Create a synchronization Model Wizard from within Sybase Central by clicking on the item in MobiLink's tasks pane shown above, which opens the window shown in the next picture. To begin you need a name for the new synchronization model and a place to save the model file. For this evaluation, Test10Sync is the name of the model and it is saved to the following folder accessed by the Browse button: C:\Documents and Settings\Jay\Desktop\SqlAnywhere_Final\ArticleFinal. The name of the file that will be created once the model is completely configured is: Test10Sync.mlsm.
Clicking on the Next Button in the above window will open the window shown in the next picture wherein you will check to verify whether the table(s) you plan to synchronize meet the MobiLink's primary key requirements.
Primary Key Requirements
For effective synchronization the databases must meet some requirements mostly to do with primary keys in the tables. These are:
- All tables participating in a synchronization setup should have primary keys.
It is through primary keys that the tables match up their rows participating
in the synchronization. - The application should not update the primary keys.
- New rows added to the table have unique primary keys across all databases participating in synchronization.
Read the instructions on this screen about how you may ensure primary key uniqueness and click on the Next Button.
This opens up the window shown in the following picture where you choose a data source that defines the schema that will be used in the consolidated database.
Next: Data Source for the consolidated database schema >>
More Database Code Articles
More By Jayaram Krishnaswamy
