Filter
Top Products
Pre-upgrade tasks
68 Adaptive Server Enterprise
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.”
2Run 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, 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
Table 5-1 shows 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.
All attributes are required, and all values are case sensitive.
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.