Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 69
Table 5-1: Resource file attributes for upgrading Adaptive Server
Upgrading using sqlupgraderes
When you have finished editing your resource file, you can run the file using
sqlupgraderes.
Note sqlupgraderes is a command line tool; therefore, unlike sqlupgrade, it
does not require any X libraries.
Source the version 15.0.2 SYBASE.csh file before running
sqlupgraderes and
set OLDSYBASE and OLDSYBASE_ASE.
To execute
sqlupgraderes, at the UNIX prompt, enter the following, where
resource_file specifies the resource file containing the attributes that describe
the server to upgrade:
$SYBASE/$SYBASE_ASE/bin/sqlupgraderes -r resource_file
Post-upgrade tasks
After you have upgraded to the new version of Adaptive Server, perform the
following tasks to make sure your new Adaptive Server is up and running.
Note After you have upgraded, you do not need to run update statistics on any
tables. The upgrade process does not cause any changes in existing statistics.
Attribute Default value [other options]
sybinit.release_directory $SYBASE [path = _name_of_old_release]
sybinit.product sqlsrv
sqlsrv.server_name server_name
sqlsrv.new_config No
sqlsrv.sa_login current_login
sqlsrv.sa_password current_password
sqlsrv.do_upgrade Yes
sqlsrv.do_reserved_word_check Yes