Share via


az sql midb move

Start, complete, cancel and list managed database move operations.

Commands

Name Description Type Status
az sql midb move cancel

Cancel managed database move operation.

Core GA
az sql midb move complete

Complete managed database move operation.

Core GA
az sql midb move list

List managed database move operations.

Core GA
az sql midb move start

Start managed database move operation.

Core GA

az sql midb move cancel

Cancel managed database move operation.

az sql midb move cancel --dest-mi
                        [--dest-resource-group]
                        [--dest-sub-id]
                        [--ids]
                        [--managed-instance]
                        [--name]
                        [--no-wait]
                        [--resource-group]
                        [--subscription]

Examples

Cancel cross subscription move operation.

az sql midb move cancel --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance --dest-rg DestinationResourceGroup --dest-sub-id DestinationSubscriptionId

Cancel cross resource group move operation.

az sql midb move cancel --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance --dest-rg DestinationResourceGroup

Cancel move operation inside same resource group.

az sql midb move cancel --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance

Required Parameters

--dest-mi

Name of the managed instance to move the managed database to.

Optional Parameters

--dest-resource-group --dest-rg

Name of the resource group to move the managed database to. If unspecified, defaults to the origin resource group.

--dest-sub-id --dest-subscription-id

Id of the subscription to move the managed database to. If unspecified, defaults to the origin subscription id.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--managed-instance --mi

Name of the Azure SQL Managed Instance.

--name -n

The name of the Azure SQL Managed Database.

--no-wait

Do not wait for the long-running operation to finish.

Default value: False
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az sql midb move complete

Complete managed database move operation.

az sql midb move complete --dest-mi
                          [--dest-resource-group]
                          [--dest-sub-id]
                          [--ids]
                          [--managed-instance]
                          [--name]
                          [--no-wait]
                          [--resource-group]
                          [--subscription]

Examples

Complete cross subscription move operation.

az sql midb move complete --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance --dest-rg DestinationResourceGroup --dest-sub-id DestinationSubscriptionId

Complete cross resource group move operation.

az sql midb move complete --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance --dest-rg DestinationResourceGroup

Complete move operation inside same resource group.

az sql midb move complete --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance

Required Parameters

--dest-mi

Name of the managed instance to move the managed database to.

Optional Parameters

--dest-resource-group --dest-rg

Name of the resource group to move the managed database to. If unspecified, defaults to the origin resource group.

--dest-sub-id --dest-subscription-id

Id of the subscription to move the managed database to. If unspecified, defaults to the origin subscription id.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--managed-instance --mi

Name of the Azure SQL Managed Instance.

--name -n

The name of the Azure SQL Managed Database.

--no-wait

Do not wait for the long-running operation to finish.

Default value: False
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az sql midb move list

List managed database move operations.

az sql midb move list [--dest-mi]
                      [--dest-resource-group]
                      [--ids]
                      [--latest]
                      [--managed-instance]
                      [--name]
                      [--resource-group]
                      [--subscription]

Examples

List all move operations from given resource group and managed instance.

az sql midb move list --resource-group MyResourceGroup --managed-instance MyInstance

List all move operations for specific managed database from given resource group and managed instance.

az sql midb move list --name mydb --resource-group MyResourceGroup --managed-instance MyInstance

List latest move operation for specific managed database from given resource group and managed instance.

az sql midb move list --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --latest

List all move operation from given resource group and managed instance into specific destination managed instance.

az sql midb move list --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance

Optional Parameters

--dest-mi

Name of the target managed instance to show move operations for.

--dest-resource-group --dest-rg

Name of the target resource group to show move operations for.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--latest --only-latest-per-database

Flag that only shows latest move operation per managed database.

Default value: False
--managed-instance --mi

Name of the source managed instance.

--name -n

The name of the Azure SQL Managed Database.

--resource-group -g

Name of the source resource group.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az sql midb move start

Start managed database move operation.

az sql midb move start --dest-mi
                       [--dest-resource-group]
                       [--dest-sub-id]
                       [--ids]
                       [--managed-instance]
                       [--name]
                       [--no-wait]
                       [--resource-group]
                       [--subscription]

Examples

Start cross subscription move operation.

az sql midb move start --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance --dest-rg DestinationResourceGroup --dest-sub-id DestinationSubscriptionId

Start cross resource group move operation.

az sql midb move start --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance --dest-rg DestinationResourceGroup

Start move operation inside same resource group.

az sql midb move start --name mydb --resource-group MyResourceGroup --managed-instance MyInstance --dest-mi DestinationInstance

Required Parameters

--dest-mi

Name of the managed instance to move the managed database to.

Optional Parameters

--dest-resource-group --dest-rg

Name of the resource group to move the managed database to. If unspecified, defaults to the origin resource group.

--dest-sub-id --dest-subscription-id

Id of the subscription to move the managed database to. If unspecified, defaults to the origin subscription id.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--managed-instance --mi

Name of the Azure SQL Managed Instance.

--name -n

The name of the Azure SQL Managed Database.

--no-wait

Do not wait for the long-running operation to finish.

Default value: False
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.