Copy-AzSqlInstanceDatabase
Copy managed database to another managed instance.
Syntax
MoveCopyManagedDatabaseByNameParameterSet (Default)
Copy-AzSqlInstanceDatabase
-DatabaseName <String>
-InstanceName <String>
-ResourceGroupName <String>
-TargetInstanceName <String>
[-TargetSubscriptionId <String>]
[-TargetResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
MoveCopyManagedDatabaseByOperationObjectParameterSet
Copy-AzSqlInstanceDatabase
-MoveCopyOperationObject <ManagedDatabaseMoveCopyOperation>
[-DatabaseName <String>]
[-InstanceName <String>]
[-ResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Copy-AzSqlInstanceDatabase
-InstanceName <String>
-ResourceGroupName <String>
-TargetInstanceName <String>
-DatabaseObject <AzureSqlManagedDatabaseModel>
[-TargetSubscriptionId <String>]
[-TargetResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
MoveCopyManagedDatabaseByResourceIdParameterSet
Copy-AzSqlInstanceDatabase
-InstanceName <String>
-ResourceGroupName <String>
-TargetInstanceName <String>
-ResourceId <String>
[-TargetSubscriptionId <String>]
[-TargetResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
The Copy-AzSqlInstanceDatabase cmdlet start online copy operation of a database across managed instances by using Always On availability group technology. Learn more
Examples
Example 1: Copy database to another Managed Instance in the same resource group
Copy-AzSqlInstanceDatabase -ResourceGroupName RG1 -InstanceName MI1 -Name database1 -TargetInstanceName MI2
This command copies database1 from instance MI1 to MI2
Example 2: Copy database to another Managed Instance in the different resource group
Copy-AzSqlInstanceDatabase -ResourceGroupName RG1 -InstanceName MI1 -Name database1 -TargetResourceGroupName RG2 -TargetInstanceName MI2
This command copies database1 from instance MI1 in resource group RG1 to MI2 in resource group RG2
Parameters
-AsJob
Run cmdlet in the background
Parameter properties
Type: SwitchParameter
Default value: None Supports wildcards: False DontShow: False
Parameter sets
(All)
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-Confirm
Prompts you for confirmation before running the cmdlet.
Parameter properties
Type: SwitchParameter
Default value: None Supports wildcards: False DontShow: False Aliases: cf
Parameter sets
(All)
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-DatabaseName
Name of the instance database.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False Aliases: Name
Parameter sets
MoveCopyManagedDatabaseByNameParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: True Value from remaining arguments: False
-DatabaseObject
Managed database object.
Parameter properties
Parameter sets
MoveCopyManagedDatabaseByInputObjectParameterSet
Position: Named Mandatory: True Value from pipeline: True Value from pipeline by property name: False Value from remaining arguments: False
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
Parameter properties
Type: IAzureContextContainer
Default value: None Supports wildcards: False DontShow: False Aliases: AzContext, AzureRmContext, AzureCredential
Parameter sets
(All)
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-InstanceName
Name of the source instance.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
MoveCopyManagedDatabaseByNameParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByResourceIdParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-MoveCopyOperationObject
Managed database move or copy operation object.
Parameter properties
Parameter sets
MoveCopyManagedDatabaseByOperationObjectParameterSet
Position: Named Mandatory: True Value from pipeline: True Value from pipeline by property name: False Value from remaining arguments: False
-PassThru
Signal to receive output from a cmdlet which does not return anything
Parameter properties
Type: SwitchParameter
Default value: None Supports wildcards: False DontShow: False
Parameter sets
(All)
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-ResourceGroupName
Name of the source resource group.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
MoveCopyManagedDatabaseByNameParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByResourceIdParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-ResourceId
Resource id of managed database.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
MoveCopyManagedDatabaseByResourceIdParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: True Value from remaining arguments: False
-TargetInstanceName
Name of the target Azure SQL Managed Instance.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
MoveCopyManagedDatabaseByNameParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByInputObjectParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByResourceIdParameterSet
Position: Named Mandatory: True Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-TargetResourceGroupName
Name of the target resource group.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
MoveCopyManagedDatabaseByNameParameterSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByInputObjectParameterSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByResourceIdParameterSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-TargetSubscriptionId
Id of the target subscription.
Parameter properties
Type: String
Default value: None Supports wildcards: False DontShow: False
Parameter sets
MoveCopyManagedDatabaseByNameParameterSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByInputObjectParameterSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
MoveCopyManagedDatabaseByResourceIdParameterSet
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Parameter properties
Type: SwitchParameter
Default value: None Supports wildcards: False DontShow: False Aliases: wi
Parameter sets
(All)
Position: Named Mandatory: False Value from pipeline: False Value from pipeline by property name: False Value from remaining arguments: False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable,
-InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable,
-ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see
about_CommonParameters .
Outputs