MobiLink Synchronization Wizard in SQL Anywhere 10 - Fine tuning the model using the Sybase Central Management Interface
(Page 7 of 8 )
When the model is completed, the model details are also available in the MobiLink Model Tasks list in Sybase Central as shown in the next picture. In this window you can perform several activities related to the synchronization model and make changes if needed. It allows a wide range of tuning using the graphical interface.
When you double click the icon of the model in the above view of Sybase Central, you can access other details that you may modify before deployment. The next picture shows the Mappings, in particular the column mappings. The details in the lower pane will not appear in the default view of this window. When the Mappings tab is in view, you need to click in the region shown by annotation to see the column details. For the top tab, Mappings, you can see a number of tabs in the bottom. Each of these represents graphically the choices made during the model generation.
By clicking on the "Dir" column you can choose any of the three options to be effective while synchronizing as shown in the next picture. Here the 'Bidirectional' option (default) is chosen for this exercise. The other options for deleted rows and conflict resolution were chosen during model generation. In the present tutorial only one table was chosen, but you may switch to another table/tables if such were the case. You could also specify a different subset for the download. Of course in this case all remote databases (only one in the present case) receive the same data.
When you tab to the 'Events' tab you will see the display shown in the next picture. The drop-down list can be used to add other events if necessary, but the script must be created by the developer (Sybase Central will not provide scripts).
Tabbing to the Authentication tab displays other authentication options to access the model. In the present case, the default, MobiLink's authentication, will be used. Email, POP3, and LDAP are other options.
Tabbing to the next tab, Notifications, displays the view shown in the next picture. The Download cursor seen earlier in the events is shown here. The polling is every 30 seconds by default, which may be changed (30 seconds to one hour). The isolation level choices are also shown. For details on isolation levels and how they affect performance, seek information at the SQL Anywhere web site. In general the higher the numeric value of isolation level the higher the protection but the lower the concurrency. At isolation level 1, which is the default in this exercise, dirty reads are prevented with greater cursor stability.
Model related objects in Sybase Central
After the model is created, model related information may be accessed in Sybase Central from the MobiLink plug-in. In order the access this information you need to log in to the Consolidated database. This gives access to the various objects of the model in MobiLink as shown in Appendix 3.
Next: Summary >>
More Database Code Articles
More By Jayaram Krishnaswamy
