Important upgrade precautions

There are several precautions you should take before upgrading any application, and these apply to SQL Anywhere upgrades just as to any other software:

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

  • 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   Validate your database, and back up your existing software and database. In addition, as recovery cannot happen across a database upgrade, make a backup after upgrading to ensure recoverability going forward.

  • 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.