Complete-AzSqlInstanceDatabaseCopy
Complete online copy operation of a managed database.
Syntax
MoveCopyManagedDatabaseByNameParameterSet (Default)
Complete-AzSqlInstanceDatabaseCopy
-DatabaseName <String>
-InstanceName <String>
-ResourceGroupName <String>
-TargetInstanceName <String>
[-TargetSubscriptionId <String>]
[-TargetResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
CompleteManagedDatabaseCopyByCopyModelObject
Complete-AzSqlInstanceDatabaseCopy
-CopyModelObject <MoveCopyManagedDatabaseModel>
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
MoveCopyManagedDatabaseByOperationObjectParameterSet
Complete-AzSqlInstanceDatabaseCopy
-MoveCopyOperationObject <ManagedDatabaseMoveCopyOperation>
[-DatabaseName <String>]
[-InstanceName <String>]
[-ResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Complete-AzSqlInstanceDatabaseCopy
-InstanceName <String>
-ResourceGroupName <String>
-TargetInstanceName <String>
-DatabaseObject <AzureSqlManagedDatabaseModel>
[-TargetSubscriptionId <String>]
[-TargetResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
MoveCopyManagedDatabaseByResourceIdParameterSet
Complete-AzSqlInstanceDatabaseCopy
-InstanceName <String>
-ResourceGroupName <String>
-TargetInstanceName <String>
-ResourceId <String>
[-TargetSubscriptionId <String>]
[-TargetResourceGroupName <String>]
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
The Complete-AzSqlInstanceDatabaseCopy cmdlet complete copy operation of a database between two Azure SQL Managed Instances. Destination database will become online and ready for read/write workloads.
Examples
Example 1: Complete copy database to another Managed Instance in the same resource group
Complete-AzSqlInstanceDatabaseCopy -ResourceGroupName RG1 -InstanceName MI1 -Name database1 -TargetInstanceName MI2
This command completes copy operation of database1 on instance MI1 to instance MI2
Example 2: Complete copy database to another Managed Instance in the different resource group
Complete-AzSqlInstanceDatabaseCopy -ResourceGroupName RG1 -InstanceName MI1 -Name database1 -TargetResourceGroupName RG2 -TargetInstanceName MI2
This command completes copy operation of database1 on instance MI1 in resource group RG1 to instance 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
-CopyModelObject
Object that is returned from start copy operation.
Parameter properties
Parameter sets
CompleteManagedDatabaseCopyByCopyModelObject
Position: Named Mandatory: True Value from pipeline: True 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