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 3: Creating a MobiLink project and synchronization model

In this lesson, you use the Create Project Wizard to create a new MobiLink project. The Create Project Wizard also creates a synchronization model using the defaults, which can be edited later.

Prérequis

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. From Sybase Central, click Tools » MobiLink 16 » New Project.

    The Create Project Wizard appears.

  2. In the Name field, type mlintro_project.

  3. In the Location field, type C:\MLintro. Click Next.

  4. In the Database display name field, type mlintro_consdb.

  5. In the Connection string field type dsn=mlintro_consdb and then click Next.

  6. Ensure that the Product table is selected from the Which consolidated database tables and columns do you want to have in your remote database list, and then click Next.

  7. Select the Add a remote schema name to the project option.

  8. In the What do you want to name the new remote schema field, type sync_mlintro and click Next.

  9. Select SQL Anywhere for the Which type of remote database do you want to use option and click Finish.

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

    A synchronization model with the same name as your remote schema is created.

  11. Select the Product table row from the Mappings tab.

  12. On the Download Type tab in the Details pane, select Timestamp for the Download Type.

  13. Select Use shadow table to hold timestamp column.

    Using shadow tables is often preferred because it does not require any changes to existing tables. In contrast, the default setting adds a timestamp column to your table and typically has better performance.

  14. To save the changes to the synchronization model, choose File » Save.

Résultat

The MobiLink project, a remote schema name, and a synchronization model are created.

 See also