Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Introducing MobiLink

 

Lesson 4: Testing your synchronization model

This lesson demonstrates how to quickly test your synchronization model.

Prerequisites

This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up a MobiLink consolidated database.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Introducing MobiLink.

 Task

  1. In the left pane of Sybase Central under MobiLink 16, expand mlintro_project » Synchronization Models » sync_mlintro.

  2. Click File » Test.

  3. Click OK to dismiss the warning indicating that your consolidated database will be modified.

    The synchronization model is deployed to the consolidated database and a remote database is created for testing purposes. The MobiLink server is started.

  4. Click the Data tab. The top pane shows rows from the Product table in the consolidated database. The bottom pane shows that the remote database currently contains no rows in the Product table.

    If more than one table were defined, the Show dropdown list would let you select which table to view.

  5. Click Synchronize. The three rows now appear in the remote database.

  6. Select the Client Log tab. Scan the log for error messages or warnings. Do the same on the MobiLink Log tab.

  7. Click the Data tab. In the lower pane, right-click the row with the name Drywall Screws 10lb, select Edit Row, and then change the quantity to 99.

  8. Click Synchronize. The change made on the remote database has been synchronized to the consolidated database.

  9. Click the Actions button and then select Open Interactive SQL on the consolidated database. The Interactive SQL window opens with a connection to the consolidated database.

  10. Execute the following SQL statements and then close Interactive SQL:

    update product set quantity = quantity + 1;
commit;

  11. Back in the Data tab in Sybase Central, click Actions » Refresh Data tab. You can see the updated rows in the consolidated database.

  12. Click Synchronize. The remote database is updated with the new quantity values.

  13. Close the Test window.

Results

You have successfully tested the synchronization model.

Next

Proceed to Lesson 5: Refining a synchronization model.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0