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 12 plug-in for Sybase Central, choose Folders from the View menu. Open your MobiLink project and expand Consolidated Databases. 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, the system setup is checked when you connect to your server database. If your database requires setup, you are prompted
to continue. See Introduction to synchronization 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.
The database user who runs the setup scripts is expected to be the same one used to update the MobiLink system tables during
synchronization. This users must be used 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:
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.
The MobiLink server needs an ODBC connection to your consolidated database. You must configure the appropriate ODBC driver
for your RDBMS and create an ODBC data source for the database on the computer where your MobiLink server is running.