且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Windows Azure SQL数据库上数据库的交叉订阅复制

更新时间: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