Creating models

Set up a MobiLink application with the Create Synchronization Model Wizard
  1. Choose Programs » SQL Anywhere 11 » Sybase Central.

  2. Choose Tools » MobiLink 11 » Set Up MobiLink Synchronization.

  3. On the Welcome page, choose a name and location for your model. Your model is stored in a model file with the extension .mlsm. Click Next.

  4. On the Primary Key Requirements page, select the three checkboxes. For more information about primary keys, see Maintaining unique primary keys. Click Next.

  5. On the Consolidated Database Schema page, click Choose A Consolidated Database and select the database. Click Next.

    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 Create Synchronization Model 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