Upgrade utility unsupported for upgrading to version 10
The Upgrade utility (dbupgrad) cannot be used to upgrade version 9.0.2 and earlier databases to version 10. To upgrade older databases to version 10, you must rebuild the database by performing an unload and reload. See Upgrading SQL Anywhere.
Updates the system tables and views, adds new database options, and recreates all system stored procedures, as well as installing jConnect support and changing support for Java in the database.
dbupgrad [ options ]
Use this option to read in options from the specified environment variable or configuration file. See Using configuration files.
If you want to protect passwords or other information in the configuration file, you can use the File Hiding utility to obfuscate the contents of the configuration file. See File Hiding utility (dbfhide).
|-c "keyword=value; ..."||
Specify connection parameters. See Connection parameters.
The user ID must have DBA authority.
For example, the following command upgrades a database called sample10 and does not install jConnect support, connecting as user DBA with password sql:
dbupgrad -c "UID=DBA;PWD=sql;DBF=c:\sa10\sample10.db" -i
If you want to use the Sybase jConnect JDBC driver to access system catalog information, you need to install jConnect support. Use this option if you want to exclude the jConnect system objects. You can still use JDBC, as long as you do not access system information. If you want, you can add Sybase jConnect support later using Sybase Central or the ALTER DATABASE UPGRADE statement. See Installing jConnect system objects into a database and ALTER DATABASE statement.
|-o filename||Write output messages to the specified file.|
|-q||Run in quiet mode—do not display messages or windows.|
The dbupgrad utility upgrades a database created with earlier versions of the software to enable features from the current version of the software. The earliest version that can be upgraded is SQL Anywhere 10.0.0. While later versions of the database server can run against databases that were created with earlier releases of the software, some of the features introduced since the version that created the database are unavailable unless the database is upgraded.
Databases with materialized views
It is recommended that you refresh the materialized views in your database after upgrading the database. See Refreshing materialized views.
You can use the Upgrade utility to update the system tables and views, add new database options, restore database options, and recreate all system stored procedures, as well as install jConnect support and change support for Java in the database.
As new versions and software updates become available for SQL Anywhere, you can use the Upgrade utility to take advantage of the new features.
Upgrading a database does not require you to unload and reload your database.
If you want to upgrade a version 9.0.2 or earlier database to version 10, you must rebuild the database by performing an unload and reload. See Upgrading SQL Anywhere.
If you want to use replication on an upgraded database, you must also archive your transaction log and start a new one on the upgraded database.
You can access the Upgrade utility in the following ways:
From Sybase Central, using the Upgrade Database wizard.
From Interactive SQL, using the ALTER DATABASE UPGRADE statement. See ALTER DATABASE statement.
At a command prompt, using the dbupgrad command.
Back up before upgrading
As with any software, it is recommended that you make a backup of your database before upgrading.
Exit codes are 0 (success) or non-zero (failure). See Software component exit codes.
Not all features made available
Features that require a physical reorganization of the database file are not made available by dbupgrad. Such features include index enhancements and changes in data storage. To obtain the benefits of these enhancements, you must unload and reload your database. See Upgrading SQL Anywhere.