You can use the dbunload utility to upgrade a version 10 or later SQL Anywhere database to the latest version.
The database user specified in the connection-string must have the SELECT ANY TABLE and SERVER OPERATOR system privileges.
Follow the standard precautions for upgrading software. See Upgrade and rebuild precautions.
Ensure that you have exclusive access to the database being upgraded and ensure that the path of the version 16 utilities is ahead of the path of the other utilities in your system path. See How to ensure that you are running the correct version of the utilities when you have multiple versions installed.
Ensure that the database is backed up before unloading and reloading. For example:
dbbackup -c "DBF=mydb.db;UID=DBA;PWD=sql" old-db-backup-dir
Context and remarks
When using dbunload with a version 10 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 returned.
If you are rebuilding a database that is a remote database in a MobiLink installation or that is involved in SQL Remote replication, and if you use the dbunload utility, you must be sure to use the -ar or -an option. These options ensure that the transaction log offsets for the new database are set to match those of the old database.
Run the Unload utility (dbunload) and use the -an option to create a database.
dbunload -c "connection-string" -an new-db-file
This command creates a database. To replace the existing database with an upgraded database, use the -ar option instead of -an. To use the -ar option, connect to a personal database server, or to a network database server on the same computer as the Unload utility (dbunload).
For information about other Unload utility (dbunload) options, see Unload utility (dbunload).
Shut down the database and archive the transaction log before using the reloaded database.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|