Synchronization model deployment

You deploy synchronization models with the Deploy Synchronization Model Wizard.

The following items can be deployed:

Changes to the consolidated database.
SQL Anywhere or UltraLite remote databases (you can choose to create a database, or add tables to an existing empty database, or use an existing database that already has your remote tables).
Batch files to deploy the model (the generated batch files have variable declarations at the beginning that you can edit before running the batch files).
Batch files to run the MobiLink server and the MobiLink client.
Server-initiated synchronization configuration.

Deploying to the consolidated database

The Deploy Synchronization Model Wizard provides two options for deploying to the consolidated database:

Apply your synchronization model directly to your consolidated database by populating MobiLink system tables and creating all required shadow tables, columns, triggers, and stored procedures.
Create a UTF-8 encoded SQL file that contains all the same changes and a batch file to run the SQL file against your consolidated database. You can inspect this file, alter it, and run it anytime. The effect is identical to applying the changes directly.

Deploy a consolidated database from a SQL file

Note

If your deployment creates shadow tables, you must connect to the consolidated database as either the owner of the base tables for which shadow tables are created, or as an administrator.

When you ran the Deploy Synchronization Model Wizard, if you chose to create a file to run later (on the Consolidated Database Deployment Destination page), you must run the batch file that is located in the consolidated sub-folder of your model. This file creates all the objects you chose to have created in the consolidated database, including synchronization scripts, shadow tables, and triggers. It can also register MobiLink users in the consolidated database.

To run this file, navigate to the consolidated directory and run the file that ends with _consolidated.bat or _consolidated.sh. You must include connection information. For example, run:

MyModel_consolidated.bat "DSN=my_odbc_datasource;UID=myuserid;PWD=mypassword"

For some drivers, the ODBC data source can include the user ID and password so they do not need to be specified.

Deploying remote databases

You can choose to use an existing remote database or have the wizard create one for you. The wizard can create remote databases directly or you can have it create a UTF-8 encoded SQL file and a batch file that you run to create or update remote databases.

The wizard creates a remote database (either SQL Anywhere or UltraLite) with default database creation options using the database owner that you specified in the model. Alternatively, you can create a remote database outside the Deploy Synchronization Model Wizard with your own custom settings and use the wizard to add the required remote tables, or you can deploy to an existing remote database that already has the remote tables.

Deploy a remote database from a SQL file

When you ran the Deploy Synchronization Model Wizard, if you chose to create a file to run later (on the New SQL Anywhere Remote Database page or New UltraLite Remote Database page), you must run the batch file that was created with the SQL file in the remote directory. This file creates all the objects you chose to have created in the remote database, including tables, publications, subscriptions, and MobiLink users.

To run this file, navigate to the remote directory and run the file that ends with _remote.bat or _remote.sh. For example, run:
MyModel_remote.bat
You are prompted for a password if you are using an existing remote database.

Deploying batch files to run synchronization tools

The wizard can create the following batch files:

A batch file to run the MobiLink server with options that you specify.
For SQL Anywhere remote databases, a batch file to run dbmlsync with options that you specify.
For UltraLite remote databases, a batch file to run ulsync with options that you specify. Ulsync is used for testing synchronization, so it helps you get started when you don't have a working UltraLite application.
If you set up server-initiated synchronization for your synchronization model, the Deploy Synchronization Model Wizard can also create batch files to run the Notifier and the MobiLink Listener.

Deploy a model

In the Folders view of Sybase Central, expand MobiLink 12, your MobiLink project name, Synchronization Models, and then select your synchronization model name.
From the File menu, click Deploy.
Follow the instructions in the Deploy Synchronization Model Wizard.
When you are finished, the changes you selected are deployed. If there are existing files of the same name, they are overwritten.
To synchronize your application, see Deployed model synchronization.

Synchronization model redeployment
Deployed model synchronization

Discuss this page in DocCommentXchange.