Installation Guide Adaptive Server Enterprise for Linux/Intel

Home

Installation Guide Adaptive Server Enterprise for Linux/Intel

Chapter 8 Upgrading Sybase Servers

Upgrading to Adaptive Server 12.5

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:

Edit the sample resource file included in your Adaptive Server distribution in $SYBASE/$SYBASE_ASE/init/sample_resource_files/upgrade.rs. Use an ASCII text editor to edit the resource file as described in Appendix A, "Alternative Installation Methods. ".
Run the sqlupgrade utility. This utility creates a new file containing the values you specified for that upgrade session, and writes it to:
$SYBASE/$SYBASE_ASE/init/logs/sqlupgradeMMDD.NNN-server_name.rs
where server_name is the name of the upgraded server.
Warning!
Be sure to change device names in the resource file, if necessary, before executing the resource file using sqlupgraderes.
For details on the attributes used in a resource file, see "Resource file attributes for upgrading Adaptive Server ".

Resource file attributes for upgrading Adaptive Server

Table 8-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_ASE/init/sample/upgrade 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.

Resource file attributes for upgrading Adaptive Server
Attribute	Default value [other options]
sybinit.release_directory	$SYBASE [path_name_of_old_srv]
sybinit.product	sqlsrv
sqlsrv.server_name	server_name
sqlsrv.new_config	no (required value)
sqlsrv.sa_login	current_login
sqlserv.sa_password	current_password
sqlsrv.do_upgrade	yes (required value)

Upgrading using sqlupgraderes

When you have finished editing your resource file, you can run the file using sqlupgraderes.

sqlupgraderes is a command-line tool; therefore, unlike sqlupgrade, it does not require any X libraries.

To execute sqlupgraderes, at the UNIX prompt, enter:

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

where resource_file specifies the resource file containing the attributes that describe the server to upgrade.


	Expand Search