Share via

az sql midb copy

  • Reference

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

Commands

Name Description Type Status
az sql midb copy cancel

Cancel managed database copy operation.

 Core GA
az sql midb copy complete

Complete managed database copy operation.

 Core GA
az sql midb copy list

List managed database copy operations.

 Core GA
az sql midb copy start

Start managed database copy operation.

 Core GA

az sql midb copy cancel

Edit

Cancel managed database copy operation.

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

Examples

Cancel cross subscription copy operation.

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

Cancel cross resource group copy operation.

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

Cancel copy operation inside same resource group.

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

Required Parameters

--dest-mi

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

Optional Parameters

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

Name of the resource group to copy 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 copy complete

Edit

Complete managed database copy operation.

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

Examples

Complete cross subscription copy operation.

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

Complete cross resource group copy operation.

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

Complete copy operation inside same resource group.

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

Required Parameters

--dest-mi

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

Optional Parameters

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

Name of the resource group to copy 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 copy list

Edit

List managed database copy operations.

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

Examples

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

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

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

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

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

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

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

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

Optional Parameters

--dest-mi

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

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

Name of the target resource group to show copy 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 copy 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 copy start

Edit

Start managed database copy operation.

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

Examples

Start cross subscription copy operation.

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

Start cross resource group copy operation.

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

Start copy operation inside same resource group.

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

Required Parameters

--dest-mi

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

Optional Parameters

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

Name of the resource group to copy 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.