The Upgrade utility
146
Switch Description
–c "keyword=value; ..." Supply database connection parameters
–i
Do not install Sybase jConnect support
–j
Do not install Sybase runtime Java classes
–o filename Log output messages to a file
–q
Quiet mode—no windows or messages
The dbupgrad command-line utility upgrades a database created with
Watcom SQL 3.2, Watcom SQL 4.0, or SQL Anywhere 5.0 to the Adaptive
Server Anywhere format. 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.
$ For more information about the command-line switches, see "Upgrade
utility options" on page 146.
Upgrade utility options
Connection parameters (–c) For a description of the connection
parameters, see "Connection parameters" on page 64 of the book ASA User’s
Guide. The user ID must have DBA authority.
For example, the following command upgrades a database called sample40
to a 7.0 format, connecting as user
DBA with password SQL:
dbupgrad -c "uid=DBA;pwd=SQL;dbf=c:\wsql40\sample40.db"
The
dbupgrad
command-line utility must be run by a user with DBA
authority.
Do not install Sybase jConnect support (–i) If you wish to use the
Sybase jConnect JDBC driver to access system catalog information, you
need to install jConnect support. Use this option if you wish 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.
Description
To Next Page
Loading...