MobiLink Synchronization User's Guide
  Synchronization Basics
    Consolidated database

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 that installs MobiLink system tables and stored procedures. The exception is Adaptive Server Anywhere databases, which are preconfigured with the appropriate system tables and stored procedures. For instructions on how to run the setup scripts, see the sections below for each supported RDBMS.

For more information about MobiLink system tables, see MobiLink System Tables.

For more information about stored procedures, see Stored Procedures.

ODBC connection 

In addition, the MobiLink synchronization 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 synchronization server is running.

For a summary of supported ODBC drivers, see ODBC Drivers.

For updated information and complete functional specifications, see http://www.ianywhere.com/developer/technotes/odbc_mobilink.html.

For information about configuring ODBC drivers for MobiLink consolidated databases, see Introduction to ODBC Drivers.

For specific information, see the section below for each supported RDBMS.

Setting up a Sybase Adaptive Server Anywhere consolidated database
Setting up a Sybase Adaptive Server Enterprise consolidated database
Setting up an Oracle consolidated database
Setting up an IBM DB2 consolidated database
Setting up a Microsoft SQL Server consolidated database