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 » Synchronization model deployment

 

Deploying a consolidated database from a SQL file

Use the Deploy Synchronization Model Wizard to deploy a consolidated database.

Prerequisites

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.

 Task
  • When you ran the Deploy Synchronization Model Wizard, if you chose to create a file to run later (on the Choose How To Prepare Databases For Synchronization page), you must run the batch file that is located in the project-name_deploy 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 project-name_deploy directory and run the filecons_setup.bat or cons_setup.sh. You must include connection information. For example, run:

    cons_setup.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.

Results

The consolidated database is deployed.