Contents Index Upgrading MobiLink Upgrading the MobiLink synchronization server

What's New in SQL Anywhere Studio
  Upgrading Software and Databases
    Upgrading MobiLink

Upgrading your consolidated database


You must upgrade the MobiLink system tables in your consolidated database before you can use the new MobiLink synchronization server.

If you are using an Adaptive Server Anywhere consolidated database, the usual upgrade process upgrades the MobiLink system tables—do not carry out the instructions in this section.

For more information on upgrading Adaptive Server Anywhere databases, see Upgrading a database.

The upgrade procedure is slightly different depending on whether you are upgrading from MobiLink version 6 or MobiLink version 7.

To upgrade a consolidated database (not DB2)

  1. Only if you are upgrading from MobiLink version 6, create the MobiLink system tables and stored procedures by running the setup SQL script MobiLink\setup\sync???.sql.

  2. Locate the upgrade script for your database-management system.

    The upgrade scripts are held in the MobiLink/upgrade/6.0.x or MobiLink/upgrade/7.0.x directory beneath the SQL Anywhere directory: The directory refers to the version of MobiLink from which you are upgrading.

  3. Apply the upgrade script for your database management system.

    Use an administration or Interactive SQL [dbisql] utility for your database management system to apply the SQL script.

To upgrade a DB2 consolidated database

  1. Copy the MobiLink\setup\SyncDB2.class file (DB2 version 5) or MobiLink\setup\SyncDB2Long.class file (DB2 version 6 or later) to the SQLLIB\FUNCTION directory on the DB2 server machine. You probably need to restart the instance. For details, see your DB2 documentation.

  2. Only if you are upgrading from MobiLink version 6, create the MobiLink system tables and stored procedures by running the setup SQL script MobiLink\setup\syncdb2.sql.

  3. Locate the DB2 upgrade scripts.

    The upgrade scripts are held in the MobiLink/upgrade/6.0.x or MobiLink/upgrade/7.0.x directory beneath the SQL Anywhere directory: The directory refers to the version of MobiLink from which you are upgrading.

    IBM DB2 UDB version 5 allows only 18-character table and procedure names. Newer versions allow longer names. There are two upgrade scripts for DB2 databases:

  4. For DB2 UDB 5.x databases only:

  5. For DB2 UDB 6 databases or higher only:


Contents Index Upgrading MobiLink Upgrading the MobiLink synchronization server