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 technology » MobiLink plug-in for Sybase Central » Synchronization models

 

Updating schemas

Use the Update Schema Wizard to update the consolidated and remote database schemas in your synchronization model.

Prerequisites

You must have a synchronization model.

Context and remarks

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

  • You made a change to the remote database schema that needs to be included in the model.

  • You made a change to the consolidated database schema that needs to be included in the model.

    For example, you need to run Update Schema before redeploying a model that created timestamp-based download for one or more tables. The previous deployment changed the schema of the consolidated database by adding a TIMESTAMP column or shadow table, so the schema needs to be updated.

 Task
  1. Double-click the MobiLink project name.

  2. Double-click Synchronization Models.

  3. Double-click your synchronization model name and click File » Update schema.

  4. Choose one of the following options:

    • The Consolidated Database Schema   The consolidated schema in the model is updated. The remote schema in the model is unchanged.

    • The Remote Database Schema   The remote schema in the model is updated. The consolidated schema in the model is unchanged.

    • Both The Consolidated And Remote Database Schemas   Both the consolidated and remote schemas are updated in the model to match the schemas of the existing databases.

  5. Follow the instructions in the Update Schema Wizard.

    When you click Finish, no changes are made outside the model until you deploy the synchronization model; the consolidated database does not change and the remote database is not created or changed until that time.

  6. Map the new remote tables in the Mappings tab.

Results

The schema is updated.

 See also