更新时间:2023-02-02 22:20:00
我想您已经有了一个解决方案,但是对于在此登陆的任何人,您都可以使用Azure PowerShell API在源订阅中创建一个新服务器,并创建一个复制新服务器并将其切换到目标订阅
I guess you already have a solution, however for anyone landing here, you can use the Azure PowerShell API's to Create a new server in the source subscription, create a copy and switch over the new server to the destination subscription
可以在 technet
该代码是自解释性的,但是出于SO***实践的考虑,
The code is self explanatory, however in the interest of SO best practices,
代码的关键部分是
创建新服务器:
$newserver = New-AzureSqlDatabaseServer -Location $targetServerLocation -AdministratorLogin $targetServerLoginID -AdministratorLoginPassword $targetServerLoginPassword
创建数据库副本:
Start-AzureSqlDatabaseCopy -ServerName $sourceServerName -DatabaseName $sourceDatabaseName -PartnerServer $newserver.ServerName -PartnerDatabase $targetdatabaseName
传输服务器
$uri = "https://management.core.windows.net:8443/" + $sourceSubscriptionID + "/services" + "/sqlservers/servers/" + $newserver.ServerName + "?op=ChangeSubscription"
Invoke-RestMethod -Uri $uri -CertificateThumbPrint $certThumbprint -ContentType $contenttype -Method $method -Headers $headers -Body $body