Using Sqlupgraderes

You can upgrade Adaptive Server 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 directory. Use an ASCII text editor to edit the resource file as described in Alternative Installation Methods.
2. Run the sqlupgraderes utility. This utility 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 name of the upgraded server, MM is the month, DD is the date, and NNN is a three-digit number identifying the srvbuild session.

   For details on the attributes used in a resource file, see Resource file attributes for upgrading Adaptive Server, below.

• Resource File Attributes for Upgrading Adaptive Server
  Look here to learn about the resource file attribute names, their default values, and other options, which you use in the resource file for upgrading Adaptive Server. The sample resource file in the $SYBASE/$SYBASE_ASE/init/sample_resource_files file included in your Adaptive Server distribution shows examples of these attributes.