Copy-AzSqlInstanceDatabase
將受控資料庫複製到另一個受控實例。
Syntax
Copy-AzSqlInstanceDatabase
-DatabaseName <String>
-InstanceName <String>
-ResourceGroupName <String>
[-TargetResourceGroupName <String>]
-TargetInstanceName <String>
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Copy-AzSqlInstanceDatabase
[-DatabaseName <String>]
[-InstanceName <String>]
[-ResourceGroupName <String>]
-MoveCopyOperationObject <ManagedDatabaseMoveCopyOperation>
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Copy-AzSqlInstanceDatabase
-InstanceName <String>
-ResourceGroupName <String>
[-TargetResourceGroupName <String>]
-TargetInstanceName <String>
-DatabaseObject <AzureSqlManagedDatabaseModel>
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Copy-AzSqlInstanceDatabase
-InstanceName <String>
-ResourceGroupName <String>
[-TargetResourceGroupName <String>]
-TargetInstanceName <String>
-ResourceId <String>
[-AsJob]
[-PassThru]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
Copy-AzSqlInstanceDatabase Cmdlet 會使用 Always On 可用性群組技術,跨受控實例啟動資料庫的在線複製作業。 深入了解
範例
範例 1:將資料庫複製到相同資源群組中的另一個 受控執行個體
Copy-AzSqlInstanceDatabase -ResourceGroupName RG1 -InstanceName MI1 -Name database1 -TargetInstanceName MI2
此命令會將 database1 從實例 MI1 複製到 MI2
範例 2:將資料庫複製到不同資源群組中的另一個 受控執行個體
Copy-AzSqlInstanceDatabase -ResourceGroupName RG1 -InstanceName MI1 -Name database1 -TargetResourceGroupName RG2 -TargetInstanceName MI2
此命令會將 database1 從資源群組 RG1 中的實例 MI1 複製到資源群組 RG2 中的 MI2
參數
-AsJob
在背景執行 Cmdlet
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
執行 Cmdlet 之前先提示您確認。
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseName
實例資料庫的名稱。
Type: | String |
Aliases: | Name |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-DatabaseObject
Managed 資料庫物件。
Type: | AzureSqlManagedDatabaseModel |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-DefaultProfile
用於與 Azure 通訊的認證、帳戶、租用戶和訂用帳戶。
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceName
來源實例的名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-MoveCopyOperationObject
受控資料庫移動或複製作業物件。
Type: | ManagedDatabaseMoveCopyOperation |
Aliases: | Operation |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-PassThru
從不會傳回任何專案的 Cmdlet 接收輸出的訊號
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
來源資源群組的名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceId
受控資料庫的資源標識碼。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-TargetInstanceName
目標 Azure SQL 受控執行個體 的名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TargetResourceGroupName
目標資源群組的名稱。
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
顯示執行 Cmdlet 後會發生的情況。 未執行 Cmdlet。
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
輸入
ManagedDatabaseMoveCopyOperation