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

SQL Anywhere 11.0.0 » MobiLink - Getting Started » Using MobiLink Technology » MobiLink models


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 11 » Sybase Central.

  2. From the Tools menu, choose MobiLink 11 » Set Up 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.

    For more information, see Maintaining unique primary keys.

  5. The Consolidated Database Schema page appears. You must connect to 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 Deploy Synchronization Model Wizard or by applying setup files yourself.)

    For more information, 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 the table ownership you set up.

  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.


Remote database
Changing your consolidated database