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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Exploring the CustDB Samples for UltraLite » Lesson 5: Browsing MobiLink synchronization scripts

Lesson 5: Browsing MobiLink synchronization scripts Next Page

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. Start Sybase Central.

    Choose Programs > SQL Anywhere 10 > Sybase Central.

  2. Connect to the consolidated CustDB database.

    1. Choose Connections > Connect with MobiLink 10.

      The Connect dialog appears.

    2. Select ODBC Data Source Name and choose SQL Anywhere 10 CustDB.

      Click OK.

  3. Open the Connection Scripts folder.

    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.

  4. Open the Synchronized Tables folder, and open the ULCustomer table folder.

    The right pane lists a set of scripts that are specific to this table, and their corresponding events. These scripts control the way that data in the ULCustomer table is synchronized with the remote databases.

See also