You deploy synchronization models with the Deploy Synchronization Model Wizard.

The following items can be deployed:

In the MobiLink 16 plug-in, schemas are compared when you deploy a synchronization model. Only database objects (for example, tables, indexes, and so on) that are different from the objects being deployed are modified. You are warned if deploying the new objects will break the existing synchronization system and you are given the chance to abort the operation. This functionality is not available for IBM DB2 LUW consolidated databases.

Redeploying updates to the same script version automatically removes schema no longer required by the new script version. For example, if a last_modified column is added to a table to support downloads but you change to upload only synchronization, then the last_modified column is dropped during deployment.

You can also use the ml_model_drop system procedure to remove a synchronization model and its schema from the consolidated database. This system procedure drops the synchronization scripts and any schema that was created when the synchronization model was deployed, including shadow tables, tracking columns, triggers, and indexes. Schema that is shared with another script_version is not deleted. Only schema installed using the MobiLink 16 plug-in can be dropped. This functionality is not available for IBM DB2 LUW consolidated databases. See ml_model_drop system procedure.

 Deploying to the consolidated database