Upgrade a tenant database to the same major and minor version as the cloud server that it is running on.
CALL DBCloud.UpgradeDatabase ( database=database [, optional-parameters ] )
dbcloudcmd run UpgradeDatabase database [ optional-parameters ]
The database to upgrade. Accepts a search query that identifies one database, for example a database name or ID. (Required)
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.
Creates a backup of the database on this host before upgrading. The default is for the cloud to choose an appropriate host.
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.
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