preupgrade

Performs tests on an installation or database to determine its readiness for upgrade, and reports found problems.

The utility is located in:
  • (UNIX) $SYBASE/$SYBASE_ASE/upgrade.

  • (Windows) %SYBASE%\%SYBASE_ASE%\upgrade, as preupgrd.exe.

Syntax

preupgrade [-v] [-h] [-N]
	[-p [skip_sybprocs]
	[-D database_name]
	[-I interfaces_file]
	[-P password]
	[-S server_name]
	[-U user_name]
	[-X option[,option]...]

Parameters

Examples

Permissions

The user login specified by the -U parameter must have system administrator privileges to run preupgrade on the server specified by the -S parameter.

When using the -D parameter to check an offline database, preupgrade must log in as user “sa.” The “sa_role” privilege is insufficient.

Related concepts
Utility Commands Reference
Installation or Configuration Utilities
Related reference
sqlupgrade
sqlupgraderes