Setting up a consolidated database

Setup scripts

To set up a database so that it can be used as a MobiLink consolidated database, you must run a setup script. Your SQL Anywhere
installation includes a script for each of the supported RDBMSs. These scripts are all located in install-dir\MobiLink\setup. You can also use the following methods to update the MobiLink system setup:

In the MobiLink plug-in for Sybase Central, choose Mode » Admin and connect to your server database. Right-click the database name and choose Check MobiLink System Setup. If your database requires setup, you are prompted to continue.

When you use the Create Synchronization Model Wizard or Deploy Synchronization Model Wizard, system setup is checked when you connect to your server database. If your database requires setup, you are prompted to continue.
See Introduction to MobiLink models.

The MobiLink setup script adds MobiLink system tables, stored procedures, triggers, and views to your database. These tables
and procedures are required for MobiLink synchronization.

You can view each setup script in a text editor if you want to check what it does.

Caution

The database user who runs the setup scripts is given permission to update the MobiLink system tables, which is required to
start the MobiLink server and to configure MobiLink. See Required permissions.

For instructions on how to run the setup scripts, see the section for your RDBMS:

Note

If the consolidated database you are setting up is to be used as a QAnywhere Server Store, the database should be configured
to be case insensitive for comparisons and string operations.

ODBC connection

The MobiLink server needs an ODBC connection to your consolidated database. You must configure the appropriate ODBC driver
for your server and create an ODBC data source for the database on the computer where your MobiLink server is running.