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:

   • upgrade_db2tolong.sql    For use with DB2 version 6 and higher.

   • upgrade_db2.sql    For use with DB2 version 5.

4. For DB2 UDB 5.x databases only:

   • Copy upgrade_db2.sql and modify the copy. Change the CONNECT statement at the start of the script so it will work with the instance you want to connect to.

   • Apply the copied SQL script to the consolidated database.

     If an error occurs because the ml_add_user script is not defined when it is dropped, you may safely ignore the error.

5. For DB2 UDB 6 databases or higher only:

   • Copy upgrade_db2tolong.sql and modify the copy. Change the CONNECT statement at the start of the script so it will work with the instance you want to connect to.

   • Apply the copied SQL script to the consolidated database.

     If an error occurs because the ml_add_user script is not defined when it is dropped, you may safely ignore the error.