Upgrading Noninteractively Using sqlupgraderes

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.

1. Edit the sample resource file included in your Adaptive Server distribution in $SYBASE/$SYBASE_ASE/init/sample_resource_files. Use a text editor to edit the resource file.
2. Run the sqlupgraderes utility, which creates a new file containing the values you specified for the upgrade session, and writes it to the sqlupgradeMMDD.NNN-server_name.rs file in $SYBASE/$SYBASE_ASE/init/logs/.
   where:

   • server_name – is the server you are upgrading.
   • MM – is the month.
   • DD – is the date.
   • NNN – is a three-digit number identifying the srvbuild session.

   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.

3. To execute sqlupgraderes, enter the following at the UNIX prompt, where resource_file specifies the resource file containing the attributes that describe the server to upgrade:

   $SYBASE/$SYBASE_ASE/bin/sqlupgraderes -r resource_file