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

SQL Anywhere 11.0.0 » MobiLink - Getting Started » MobiLink Tutorials » Tutorial: Using .NET synchronization logic


Lesson 4: Test synchronization

UltraLite comes with a sample Windows client that automatically invokes the dbmlsync utility when the user issues a synchronization. It is a simple sales-status application that you can run against the CustDB consolidated database you started in the previous lesson.

Start the application

To start and synchronize the sample application

  1. Launch the sample application.

    From the Start menu, choose Programs » SQL Anywhere 11 » UltraLite » Windows Sample Application.

  2. Enter an employee ID.

    Input a value of 50 and press Enter.

The application automatically synchronizes, and a set of customers, products, and orders are downloaded to the application from the CustDB consolidated database.

In the next section you enter a new customer name and order details. During a subsequent synchronization, this information is uploaded to the CustDB consolidated database and the upload_insert and download_cursor events for the ULCustomer table triggers.

Add an order

To add an order

  1. From the Order menu, choose New.

    The Add New Order window appears.

  2. Enter a new Customer Name.

    For example, enter Frank DotNET.

  3. Choose a product, and enter the quantity and discount.

  4. Press Enter to add the new order.

You have now modified the data in your local UltraLite database. This data is not shared with the consolidated database until you synchronize.

To synchronize with the consolidated database and trigger the upload_insert event

  • From the File menu, choose Synchronize.

    A window appears indicating that one Insert successfully uploaded to the consolidated database.

Further reading

For more information about the CustDB Windows Application, see Exploring the CustDB sample for MobiLink.