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

SQL Anywhere 10.0.1 » MobiLink - Getting Started » MobiLink Models

Introduction to MobiLink models Next Page

Creating models


You create MobiLink models with the Create Synchronization Model wizard.

Create Synchronization Model wizard

The Create Synchronization Model wizard takes you through the steps of creating a MobiLink synchronization application.

Overview of setting up a MobiLink application with the Create Synchronization Model wizard
  1. Open Sybase Central.

    Choose Programs > SQL Anywhere 10 > Sybase Central.

  2. From the Tools menu, choose MobiLink 10 > Setup MobiLink Synchronization.

    The Create Synchronization Model wizard appears.

  3. Choose a name and location for your model. Your model is stored in a model file with the extension .mlsm.

    Note: The name and location are used for default names for files and directories that are created by the wizard.

  4. The Primary Key Requirements page appears.

    This page is included for safety. It reminds you to maintain unique, permanent primary keys. To continue, you must select the three checkboxes. You can disable this page for the future by selecting the box at the bottom of the page.

    See Maintaining unique primary keys.

  5. The Consolidated Database Schema page appears. You must connect to the database that will be the consolidated database in your MobiLink application so that the wizard can obtain schema information for it.

    If this database has not been set up for use as a consolidated database, the wizard prompts you to do so. The MobiLink setup process adds system objects to the database that are required by MobiLink. If you choose, these objects are added to the consolidated database immediately. (You can choose to do this setup later, either in the deployment wizard or by applying setup files yourself.)

    See Setting up a consolidated database.

    The connection to the consolidated database is closed if you choose a different consolidated database, or when you exit the wizard. From this point on, changes you make in this wizard are made to the model file, not to the consolidated database.

  6. The Remote Database Schema page appears. You can create your remote database schema based on the consolidated database or an existing remote database. The existing remote database can be SQL Anywhere or UltraLite. (When you deploy, you can apply the schema to a new or existing remote database. See Remote database.)

    For a new SQL Anywhere remote database, the owner of the remote tables is the same as the owner of the corresponding consolidated database tables. If you want a different owner, you should instead use an existing remote database with your desired table ownership.

  7. Follow the remaining instructions in the wizard. Default recommendations based on best practices are used where possible. There is online help for all the pages.

  8. Click Finish.

    When you click Finish, the model you just created opens in Model mode. At the same time, your connection to the consolidated database is closed. You are now working offline and you can make changes to the model. No changes are made outside the model until you deploy the model: the consolidated database does not change and the remote database is not created or changed until that time.

    See Model mode and Deploying models.

Notes

Remote database
Changing your consolidated database