What's New in SQL Anywhere Studio
Upgrading Software and Databases
Upgrading Adaptive Server Anywhere
There are several precautions you should take before upgrading any application, and these apply to Adaptive Server Anywhere upgrades just as to any other software.
Check the behavior changes Before upgrading, you should confirm that none of the documented behavior changes in Version 9.0 affect your application.
For more information, see Adaptive Server Anywhere behavior changes.
Test You should test your application in a Version 9 environment thoroughly before upgrading any applications in production use.
Backup You should back up your existing software and data before upgrading. In addition, as recovery cannot happen across a database upgrade, you should make a backup after upgrading to ensure recoverability going forward.
For databases involved in synchronization, such as UltraLite databases or Adaptive Server Anywhere remote databases in MobiLink or SQL Remote installations, you should synchronize all outstanding changes before upgrading.
Test your upgrade procedure If you are upgrading many end users, test your upgrade procedure carefully before carrying it out.
SQL Anywhere is used in so many different configurations that no upgrade guidelines can be guaranteed for all cases.