Before using existing applications with this version of the software, be sure to review the list of behavior changes to determine whether your application is affected. See SQL Anywhere 11 - Changes and Upgrading.
Adaptive Server Anywhere has been renamed SQL Anywhere. In this chapter, SQL Anywhere is used to refer to all versions.
If you are upgrading from version 10.0.0 or later, you can either use the Upgrade utility or rebuild your database. Upgrading or rebuilding is an optional step because the version 11 software can be used with a version 10 database. However, if you want to take advantage of all of the new features in version 11, you must rebuild your database. See Upgrading version 10.0.0 and later databases and Rebuilding version 10.0.0 and later databases.
It is recommended that you refresh the materialized views in your database after upgrading your database server, or after rebuilding or upgrading your database to work with an upgraded database server. See Refreshing manual views.
If you are upgrading to SQL Anywhere version 11.0.0 from version 9 or earlier, you must rebuild the database, which consists of unloading the old database, and reloading it into a new version 11 database. Attempting to start version 9 or earlier databases results in an error on database startup. There are four approaches for rebuilding existing databases:
The Unload utility (dbunload) has the same file name in all versions of SQL Anywhere. You must make sure you are using the correct version. See Using the utilities.
As well, when using dbunload with a version 10.0.0 or later database, the version of dbunload used must match the version of the database server used to access the database. If an older version of dbunload is used with a newer database server, or vice versa, an error is reported.
If you need to make schema changes, this is the recommended way of upgrading. After you make the schema changes, you can initialize a new database, and then apply the reload script to it.
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:
Once the database is unloaded, you can perform the reload on Mac OS X using the version 11 software.
If you want to change the characteristics of the database during unload and reload (for example, change a case-sensitive database to a case-insensitive database), the procedure is more involved. For more information, see Rebuilding databases.
A different search order is used to locate the temporary file in version 9 and earlier than is used in version 11. If you are connecting a version 9 or earlier client to a version 11 database server over shared memory, you must set the SATMP (version 11) and ASTMP (version 9 and earlier) environment variables to specify the location of the temporary file. If you do not set these environment variables, the shared memory connection attempt will fail.
Using the utilities
Important upgrade precautions
Upgrade quick start
Rebuilding version 10.0.0 and later databases
Rebuilding version 9 and earlier databases for version 11.0.0
Upgrading version 10.0.0 and later databases
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|