Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » Using UltraLite Databases » Exploring the CustDB samples for UltraLite » Lesson 5: Browsing MobiLink synchronization scripts

 

Browsing the synchronization scripts

In addition to the tables, users, and publications, you can also use Sybase Central to browse the synchronization scripts that are stored in the consolidated database. Sybase Central is the primary tool for adding these scripts to the database.

The custdb.sql file adds each synchronization script to the consolidated database by calling ml_add_connection_script or ml_add_table_script. Connection scripts control high level events that are not associated with a particular table. Use these events to perform global tasks that are required during every synchronization. Table scripts allow actions at specific events relating to the synchronization of a specific table, such as the start or end of uploading rows, resolving conflicts, or selecting rows to download.

For more information about the synchronization logic used in CustDB, see Synchronization logic source code.

To browse the synchronization scripts

  1. From the Start menu, choose Programs » SQL Anywhere 11  » Sybase Central.

  2. From the Connections menu, choose Connect With MobiLink 11.

  3. Click ODBC Data Source Name.

  4. Click Browse and choose SQL Anywhere 11 CustDB.

  5. Click OK.

  6. Click OK.

  7. Double-click Connection Scripts.

    The right pane lists a set of synchronization scripts and a set of events with which these scripts are associated. As the MobiLink server carries out the synchronization process, it triggers a sequence of events. Any synchronization script associated with an event is run at that time. By writing synchronization scripts and assigning them to the synchronization events, you can control the actions that are carried out during synchronization.

  8. Click Synchronized Tables.

  9. In the right pane, double-click ULCustomer.

    A set of scripts specific to this table, and their corresponding events appears. These scripts control the way that data in the ULCustomer table is synchronized with the remote databases.

See also