Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Task syntax

UpgradeDatabase task

Upgrade a tenant database to the same major and minor version as the cloud server that it is running on.

Syntax 1 (SQL)
CALL DBCloud.UpgradeDatabase ( database=database [, optional-parameters ] )
Syntax 2 (Cloud Command utility)
dbcloudcmd run UpgradeDatabase database [ optional-parameters ]
Parameters
  • database

    The database to upgrade. Accepts a search query that identifies one database, for example a database name or ID. (Required)

  • system_procedure_as_definer

    Applies when upgrading a database to version 16 or later software. Set to ON to have the system procedures in the upgraded database execute with the privileges of the definer or set to OFF to have the system procedures execute with the privileges of the invoker. The default is to leave this option unchanged.

    The system_procedure_as_definer parameter applies when upgrading a database to version 16 or later software. The default is to retain the invoker/definer setting of the database being upgraded.

  • backup_host

    Creates a backup of the database on this host before upgrading. The default is for the cloud to choose an appropriate host.

  • skip_backup When this optional parameter is set to 1, a backup of the database is not created and the backup_host parameter is ignored. The default is 0.
Required privileges

Administrator

Remarks

This task upgrades the database to the version of the server on which it is currently running. This task cannot upgrade a database that is involved in a mirroring or read-only scale-out system.

If the database was running before the upgrade, then it is stopped, started, upgraded, stopped, and then restarted. If the database was stopped before the upgrade, then it is started, upgraded, and stopped. Connections to the database are temporarily disabled during the upgrade.

Example

Run the following task to upgrade the database called mydatabase to the version of the server on which it is currently running. If you want to upgrade the database to a different database version, you must first use the MoveDatabase task to move it to a server running the correct version. The database must not be mirrored and must have no read-only scale-out nodes.

dbcloudcmd run UpgradeDatabase mydatabase

The following task upgrades the mydatabase database, but no backup copy of the database is created during the upgrade:

dbcloudcmd run UpgradeDatabase mydatabase 1