Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16


The rebuild process for version 9 and earlier databases

It is recommended that you back up your database before rebuilding it.


The page size for a database can be (in bytes) 2048, 4096, 8192, 16384, or 32768, with the default being the page size of the original database.

For information about upgrading Windows Mobile databases, see Database rebuilding on Windows Mobile.


SQL Anywhere 9.0.2 for Mac OS X was supported on PPC, while SQL Anywhere 10.0.0 and later for Mac OS X are supported on Intel. If you have a version 9.0.2 or earlier database on Mac OS X, you have two options for unloading the database:

  • Unload the database using the version 9.0.2 software.

  • Copy the database to a different platform where SQL Anywhere 16 is installed, and then unload the database using the version 16 software.

Once the database is unloaded, you can perform the reload on Mac OS X using the version 16 software.


Unloading and reloading a large database can be time consuming and can require a large amount of disk space. The process requires access to disk space twice the size of your database to hold the unloaded data and the new database file.

 Upgrade restrictions
 Special considerations
 Known issues

Rebuilding a version 9 or earlier database (Sybase Central)
Rebuilding a version 9 or earlier database using the Unload utility (command line)