Icon for Previous Page button Icon for Next Page button

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.