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 SQL Anywhere® 10 - Changes and Upgrading.

Test your application Test your application thoroughly in a SQL Anywhere 10 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.