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

  • Test your application   Test your application thoroughly in a SQL Anywhere 12 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 Utility versions and the upgrade process.

  • 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, back up 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.