database The database to move. Accepts a search query that identifies one database, for example a database name or ID. The database
cannot be part of a mirroring or read-only scale-out system. (Required)
server The cloud server to move the database to. Accepts a search query that identifies one cloud server, for example a cloud server
name or ID. The version of the server must be equal to or greater than the cloud server currently associated with the database.
move_method The method to use when moving the database. Accepts NULL or a comma-delimited list of the following values: online, offline,
and mirroring. The default is NULL.
move_method parameter The move_method parameter is an unordered comma-delimited list of methods the task can use to move the specified database.
The default value, NULL, is equivalent to a comma-delimited list of all available methods (mirroring,online,offline), and it allows the task to choose the most appropriate method for the specified database.
mirroring Specifying mirroring as the move_method sets a temporary arbiter server, if necessary, and creates a scale-out database copy for the database
on the target cloud server. This scale-out database copy is converted to a mirror database, the original database copy is
dropped, and the arbiter setting is removed, if necessary. This method requires at least three running cloud servers, but
causes the least downtime. Do not specify this method to move an autostart database.
online Specifying online for the move_method transfers the database files and disables connections, and then transfers the transaction log.
offline If the database is not running and offline is specified for the move_method, the files are moved to the specified cloud server.
This task moves a database that is not part of a mirroring or read-only scale-out system. To move a database copy that is
part of a mirroring or read-only scale-out system, use the MoveDatabaseCopy task.
Connections to the database can be temporarily disabled or dropped.