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: Using MobiLink with an Adaptive Server Enterprise consolidated database


Lesson 5: Creating a MobiLink project and synchronization model

In this lesson you connect to the consolidated database by creating a new MobiLink project. A synchronization model is created automatically when you create a new project.


This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.

This lesson assumes you have the roles and privileges listed in the Permissions and privileges section at the start of this tutorial: Tutorial: Using MobiLink with an Adaptive Server Enterprise consolidated database.

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

  2. Click Tools » MobiLink 16 » New Project.

    The Create Project Wizard appears.

  3. In the Name field, type ase_project.

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

  5. In the Database display name field, type ase_cons.

  6. Click Edit.

  7. Perform the following tasks in the Connect To A Generic ODBC Database page:

    1. In the User ID field, type sa.

    2. In the Password field, type the password for the sa account.

    3. In the ODBC Data Source name field, click Browse, and choose ase_cons.

    4. Click OK, and click Save.

  8. Select the Remember the password option, and click Next.

  9. On the New Remote Database Schema page, in the Which consolidated database tables and columns do you want to have in your remote database list, choose the following tables:

    • au_pix
    • authors
    • discounts
    • sales
    • salesdetail
    • stores
    • titleauthor
    • titles

    Click Next.

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

  11. Type ase_remote_schema for the remote schema name, and then click Next.

  12. Check SQL Anywhere and then click Finish.

    If this is the first time the consolidated database has been used by MobiLink, a message appears asking you to install the MobiLink system setup. Installing the MobiLink system setup adds MobiLink system tables and procedures. Click Yes, and then click OK.


The MobiLink project and synchronization model are created.