Consolidated database upgrades

Before you can use the new MobiLink server with an existing consolidated database, you must run upgrade scripts that install new system objects. The upgrade scripts must be run by the owner of the currently installed MobiLink system tables. You can also use the following methods to update the MobiLink system setup:

In the MobiLink plug-in for Sybase Central, click MobiLink 16 » Project » Consolidated Databases and right-click the database name and click Check MobiLink System Setup. If your database requires setup or upgrading, you are prompted to continue.
When you use the Deploy Synchronization Model Wizard, system setup is checked when you connect to your consolidated database. If your database requires setup or upgrading, you are prompted to continue. See Synchronization models.

The MobiLink upgrade scripts for 6.0.x have been removed. If you require this upgrade, contact Technical Support ( [external link] http://www.sybase.com/support).

Notes

Use the ml_add_missing_dnld_scripts stored procedure to fix missing download_cursor and/or download_delete_cursor scripts. Invoking this procedure with a script version name defines the missing download_cursor and/or download_delete_cursor scripts as ignored scripts for every synchronization table used by the given script version.
If you have authenticate_user_hashed scripts that were created earlier than version 10.0.0, change them to accept VARBINARY(32) instead of VARBINARY(20), using the binary equivalent type of your RDBMS.

Upgrading a consolidated database (SQL Anywhere 10.0.0 and later)
Upgrading a consolidated database (Adaptive Server Enterprise, SAP Sybase IQ, Oracle, MySQL, or Microsoft SQL Server)
Upgrading an IBM DB2 LUW consolidated database
Upgrading a consolidated database (SQL Anywhere earlier than 10.0.0)

Discuss this page in DocCommentXchange.