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 » Model mode

Setting up server-initiated synchronization in Model mode Next Page

Updating schemas in Model mode


The Update Schema wizard allows you to update the consolidated and remote database schemas in your model.

The Update Schema wizard is most useful after you have deployed your model and:

Unlike the Create New Remote Tables dialog, which adds remote tables to the model, the Update Schema wizard does not map the tables. You will need to create table mappings using the Mappings tab. See Modifying the remote database that your model will create.

To update the schema
  1. In Model mode, from the File menu, choose Update Schema.

    The Update Schema wizard appears.

  2. Choose the schema that you want to update.

    The Update Schema wizard compares schemas in the model with the schemas of the databases.

  3. Follow the instructions in the wizard. Each page has online help.

  4. Click Finish.

    When you click Finish, any connections to the consolidated and remote databases are closed. You are now working offline. 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.

  5. Map the new remote tables in the Mappings tab. See Modifying table and column mappings.