订阅之间的Azure SQL同步 [英] Azure SQL Sync between Subscriptions

问题描述

我有2个订阅，它们具有相同的数据库，它们将需要同步数据.使用Azure SQL Sync是否可以实现此目标?

I have 2 subscriptions which have the same database and they would need to sync the data. Is this posible to achive with Azure SQL Sync.

之所以我们拥有2个订阅，是因为其中一个是客户，另一个是客户.

Reason why we have 2 Subscriptions is becouse one of it is customers and other one is clients.

如果这不可能，那么在天蓝色的订阅之间同步2个数据库的最佳方法是什么.

If this is not possible what would be the best way to sync 2 databses between azure subscriptions.

Azure SQL数据同步

推荐答案

这是Microsoft Azure SQL数据同步团队提供的答案:

This the answer provided by Microsoft Azure SQL Data Sync team:

感谢您与我们联系.我们确实支持跨数据库同步 订阅. (实际上，这是我们的用例之一.)

Thanks for contacting us. We do support sync databases across subscriptions. (In fact, it is one of our use cases.)

如果其他订阅也属于同一租户，则可以 在添加时通过选择其他订阅直接添加它 Azure数据库:

If the other subscription also belong to the same tenant, you can directly add it by selecting a different subscription when adding Azure database:

否则，使用我们的PowerShell cmdlet可能更好 New-AzureRmSqlSyncMember ，您需要指定 "MemberServerName"参数，这是标准DNS名称 用于逻辑服务器.

Otherwise, probably it is better to use our PowerShell cmdlet New-AzureRmSqlSyncMember, you need to specify the "MemberServerName" parameter, which is the fully qualified DNS name for the logical server.

要在门户网站中查看订阅，它们必须在同一租户下 并且用户需要对他们两个都有权限.如果不是 在这种情况下，他们可以使用PowerShell添加同步成员.

To see the subscriptions in portal, they must under the same tenant and the user needs to have permission to both of them. If that’s not the case, they can add the sync member using PowerShell.

这篇关于订阅之间的Azure SQL同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！