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 12 - Changes and Upgrading.
Upgrading version 10 and later databasesIf you are upgrading from version 10 or later, you can either upgrade or rebuild your database. Upgrading or rebuilding is an optional step because the version 12 software can be used with a version 10 or later database. However, if you want to take advantage of all the new features in version 12, you must rebuild your database. See The upgrade process for version 10 and later databases and The rebuild process for version 10 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 a manual materialized view.
Upgrading version 9 and earlier databasesIf you are upgrading to version 12 from version 9 or earlier, you must rebuild the database, which consists of unloading the old database, and reloading it into a new version 12 database. Attempting to start version 9 or earlier databases results in an error on database startup. There are several approaches for rebuilding existing databases:
Use the version 12 Unload utility (dbunload) with the -an (create a new database) or -ar (replace the old database) option. See Rebuild a version 9 or earlier database using the Unload utility (command line).
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. Run the command dbunload -? to determine which version of the Unload utility you are using. See Utility versions and the upgrade process.
Unload the database using the version 12 Unload utility, and then reload the database using the reload.sql file on the version 12 database server.
If you need to make schema changes, this is the recommended way of upgrading. After you make the schema changes, you can create a new database, and then apply the reload script to it.
Use the Unload Database Wizard in Sybase Central. You can choose to create a new database, replace an existing database with the new database, or unload the database to a file. See Rebuild a version 9 or earlier database (Sybase Central).
Unload the database using an older version of dbunload, and then reload the database using the reload.sql file and the version 12 database server. You should only use this approach if the other methods fail because deprecated or unsupported database option settings, objects, or SQL syntax could be unloaded into the reload.sql file. You must edit the file manually if problems occur during the reload. The internal reload capabilities of version 12 take care of many of these problems.
SQL Anywhere 9.0.2 for Mac OS X was supported on PPC, while SQL Anywhere 10 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.
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. See Database rebuilds.
Compatibility with existing softwareSQL Anywhere 12 database servers support connections from client applications using software from version 6.0.0 or later. Version 5 and earlier clients cannot connect to a version 12 database server.
Compatibility with existing Sybase Central softwareFull support The SQL Anywhere plug-in for Sybase Central fully supports any database created by version 10 or later software running on a version 10 or later server. For example, version 10 databases running on version 10, 11, or 12 servers; version 11 databases running on version 11 or 12 database servers; and version 12 databases running on a version 12 database server.
Unload/reload-only support For databases created by version 5, 6, 7, 8, or 9 software running on a version 6, 7, 8, or 9 database server, you can connect to the database from the SQL Anywhere plug-in temporarily to do one of the following tasks:
Unload the database into a reload file.
Unload and reload the database into a new version 12 database.
Unload and reload the database into an existing version 12 database.
The files for the database being unloaded must be located on the local computer.
No support There is no support in the SQL Anywhere plug-in for databases created by version 4 or earlier software running on a version 5 or earlier server.
Utility versions and the upgrade process
Upgrade precautions
Upgrading databases
The rebuild process for version 10 and later databases
The rebuild process for version 9 and earlier databases for version 12
The upgrade process for version 10 and later databases
Troubleshooting information for upgrades
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |