PowerShell新-AzSqlDatabaseCopy:如何在复制数据库时显示进度？

Install-Module -Name Az -AllowClobber -Force

Connect-AzAccount

$copyOperation = New-AzSqlDatabaseCopy -ResourceGroupName <resource_group_name> -ServerName <server_name> -DatabaseName <source_database_name> -CopyResourceGroupName <copy_resource_group_name> -CopyServerName <copy_server_name> -CopyDatabaseName <copy_database_name>

$copyOperation | Get-AzSqlDatabaseCopy -OperationStatusLink | ForEach-Object {
    $statusLink = $_.OperationStatusLink
    $operationStatus = (Invoke-AzResourceAction -Action GET -Uri $statusLink).Properties

    $progressPercentage = $operationStatus.PercentComplete
    $estimatedCompletionTime = $operationStatus.EstimatedCompletionTime
    $sourceDatabaseSize = $operationStatus.SourceDatabaseSize
    $totalElapsedTime = $operationStatus.TotalElapsedTime
    $errorMessage = $operationStatus.ErrorMessage

    Write-Host "Progress: $progressPercentage%"
    Write-Host "Estimated Completion Time: $estimatedCompletionTime"
    Write-Host "Source Database Size: $sourceDatabaseSize"
    Write-Host "Total Elapsed Time: $totalElapsedTime"

    if ($errorMessage) {
        Write-Host "Error Message: $errorMessage"
    }

    Write-Host "---------------------"
}