Important upgrade precautions

There are several precautions you should take before upgrading SQL Anywhere:

  • Check the behavior changes   Confirm that none of the documented behavior changes affect your application. If they do, you must update your application. See What's new in version 11.0.1.

  • Test your application   Test your application thoroughly in a SQL Anywhere 11 environment before upgrading any applications in production use.

  • Use the correct version of the utilities   Make sure you use the correct version of the database utilities with your new database. See Using the utilities.

  • Validate and back up the database   Before you begin an upgrade, validate your database, and back up your software and database. To ensure future recoverability, complete a backup of the database when you finish the upgrade.

  • Synchronize before upgrading   For databases involved in synchronization, such as UltraLite databases or SQL Anywhere remote databases in MobiLink installations, you must perform a successful synchronization before upgrading.

  • Test your upgrade procedure   Test your upgrade procedure carefully before carrying it out on a production system.

SQL Anywhere is used in many different configurations, and no upgrade guidelines can be guaranteed for all cases.