Chapter 4 Database Administration Utilities
145
The Upgrade utility
The Upgrade utility upgrades a database created with older versions of the
software. While Adaptive Server Anywhere does run against databases that
were created with earlier releases of the software, some of the features that
were introduced since the version that created the database are unavailable
unless the database is upgraded.
If you want to switch to the current release to use the new features, the
Upgrade utility upgrades your databases without unloading and reloading
them.
If you wish 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
♦ From the system command-line, using the
dbupgrad
command-line
utility
Backup before upgrading
As with any software, it is recommended that you make a backup of your
database before upgrading.
Upgrading databases that are too old for the Upgrade utility
v To upgrade a database created with a version of Adaptive Server
Anywhere that is too old to be upgraded:
1 Unload the database using the Unload utility.
2 Create a database with the name you wish to use for the upgraded
version, using the Initialization utility.
3 Connect to the new database from Interactive SQL as the DBA user ID,
and read the
reload.sql
command file to build the new database.
You can also use the
dbunload
command-line utility to directly rebuild.
The dbupgrad command-line utility
dbupgrad [
switches
]Syntax
To Next Page
Loading...