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.

To upgrade an Adaptive Server using a resource file, either:

  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 Appendix A, “Alternative Installation Methods.”

  2. Run the sqlupgraderes utility. This utility creates a new file containing the values you specified for that 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.

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