Lesson 2: Run the Create Synchronization Model Wizard

This tutorial uses the demo.db sample database as your consolidated database. Your SQL Anywhere installation includes a MobiLink sample database called CustDB, but it is already set up as a MobiLink consolidated database. This tutorial starts from scratch and shows you how to set up a SQL Anywhere database to use as a consolidated database.

To run the Create Synchronization Model Wizard

  1. Start the wizard.

    • Choose Programs » SQL Anywhere 11 » Sybase Central.

      Sybase Central opens.

    • In the Task pane, choose Create A Synchronization Model. (If the Task pane is not open, click View » Tasks.)

      The Create Synchronization Model Wizard appears.

  2. Type a name and location for your model.

    • For this tutorial, name your model MLDemo.
    • Save the model in C:\temp.
    • Click Next.

  3. The Primary Key Requirements page appears. This page is informational only. Select all three checkboxes and click Next.

  4. The Consolidated Database Schema page appears. In this page, you select the database you want to use as your consolidated database. For this tutorial, you use the sample database called Demo. This sample database has not been set up for MobiLink synchronization.

    • Click Choose A Consolidated Database.

      The Connect window appears.

    • Select ODBC Data Source Name, and click the down arrow.
    • From the dropdown list, select SQL Anywhere 11 Demo.

  5. A window appears asking if you want to install System Setup. Click Yes.

    System objects are installed that make the demo database able to perform MobiLink synchronization.

  6. The Consolidated Database Schema page appears again, showing that you are connected to SQL Anywhere 11 demo. Click Next.

  7. The Remote Database Schema page appears. Select No, Create a New Remote Database Schema and click Next.

  8. The New Remote Database Schema page appears. Click Select All and then click Next.

  9. The Download Type page appears. Leave the default, Timestamp-based Download. Click Next.

  10. The Timestamp Download Options page appears. Leave the default and click Next.

  11. The Download Deletes page appears. Leave the defaults and click Next.

  12. The Download Subset page appears. Leave the default and click Next.

  13. The Upload Conflict Detection page appears. Choose Row-based Conflict Detection and click Next.

  14. The Upload Conflict Resolution page appears. Choose Consolidated Database Wins and click Next.

  15. The Production, Script Version and Description page appears. Click Next.

  16. The Completing The Create Synchronization Model page appears. Click Finish.

    Model mode opens, showing your model with all the settings you chose in the wizard.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0