Lesson 3: Creating a MobiLink project and synchronization model

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

In this lesson, you use the Create Synchronization Model Wizard to create a new synchronization model.

Before you can create a model, you must use the Create Project Wizard to create a new MobiLink project. You can then access the Create Synchronization Model Wizard from the Create Project Wizard.

 Create a new MobiLink project and synchronization model

  1. Click Start » Programs » SQL Anywhere 12 » Administration Tools » Sybase Central.

  2. Click Tools » MobiLink 12 » New Project.

    The Create Project Wizard appears.

  3. In the Name field, type mlintro_project.

  4. In the Location field, type C:\MLintro, and click Next.

  5. Select the Add A Consolidated Database To The Project option.

  6. In the Database Display Name field, type mlintro_consdb.

  7. Click Edit.

  8. Perform the following tasks on the Connect To A Generic ODBC Database page:

    1. In the User ID field, type DBA.

    2. In the Password field, type sql.

    3. In the ODBC Data Source Name field, click Browse and select mlintro_consdb.

    4. Click OK, and click Save.

  9. Select the Remember The Password option, and click Next.

  10. Select Create A New Model, and click Next.

  11. Select the Add A Remote Schema Name To The Project option.

  12. In the What Do You Want To Name The New Remote Schema field, type My Application 1.0 and click Finish.

  13. Click Yes to install the MobiLink system tables, and click OK.

    The Create Synchronization Model Wizard appears.

  14. In the What Do You Want To Name The New Synchronization Model field, type sync_mlintro and click Next.

  15. Select the mlintro_consdb consolidated database from the list, and click Next.

  16. Click No, Create A New Remote Database Schema, and click Next.

  17. On the New Remote Database Schema page, ensure that only the Product table is selected from the Which Consolidated Database Tables And Columns Do You Want To Have In Your Remote Database list, and click Next.

  18. Click Timestamp-based Download, and click Next.

    Timestamp-based downloads minimize the amount of data that is transferred because only data that has been updated since the last download is transmitted.

  19. On the Timestamp Download Options page, click Use Shadow Tables To Hold Timestamp Columns, and click Next.

    Using shadow tables is often preferred because it does not require any changes to existing tables.

  20. Perform the following tasks on the Download Deletes page:

    1. Click Yes for the Do You Want Data Deleted On The Consolidated Database To Be Deleted On The Remote Databases option.

    2. Click Use Shadow Tables To Record Deletions.

      MobiLink creates shadow tables on the consolidated database to implement deletions that can be synchronized.

    3. Click Next.

  21. Click Yes, Download the Same Data to Each Remote, and click Next.

  22. Click No Conflict Detection, and click Next.

  23. Perform the following tasks on the Publication, Script Version And Description page:

    1. In the What Do You Want To Name The Publication field, type sync_mlintro_publication.

    2. In the What Do You Want To Name The Script Version field, type sync_mlintro_scriptversion.

      The publication is the object on the remote database that specifies what data is synchronized. MobiLink server scripts define how uploaded data from remotes should be applied to the consolidated database, and script versions group scripts. You can use different script versions for different applications, allowing you to maintain a single MobiLink server while synchronizing different applications.

    3. Click Finish.

  24. Proceed to Lesson 4: Deploying the synchronization model.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1