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

SQL Anywhere 12.0.1 » SQL Anywhere 12 - Changes and Upgrading » Upgrading to SQL Anywhere 12 » SQL Anywhere Server upgrades


The rebuild process for version 9 and earlier databases for version 12

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 12 is installed, and then unload the database using the version 12 software.

Once the database is unloaded, you can perform the reload on Mac OS X using the version 12 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 approximately twice the size of your database to hold the unloaded data and the new database file.

 Upgrade restrictions
 Special considerations
 Known issues
 Rebuilding version 9 or earlier databases