You can upgrade Adaptive Server without the graphical user interface (GUI), in noninteractive mode by using values from a resource file that defines the attributes for the server to be upgraded.
If the resource file you are modifying was created by sqlupgrade, the prefix of the attribute name may vary. sqlupgraderes ignores this prefix when processing the resource file.
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 |
All attributes are required, and all values are case-sensitive.
$SYBASE/$SYBASE_ASE/bin/sqlupgraderes -r resource_file