是否已有Azure Data Sync的替代方案？ Azure自动化Runbook / powershell会是一个吗？ [英] Is there already an alternative for Azure Data Sync? Will Azure automation runbook/powershell be one?

问题描述

您好，我正在寻找Azure Data Sync的替代方案，以便将现有Azure数据库复制到另一个Azure数据库，并将内部部署数据库还原到Azure数据库。

Hi, I'm looking for an alternative to Azure Data Sync for the purpose of Duplicating an existing Azure Database to another Azure Database, and restoring an on-premise database to the Azure Database.

我知道Azure Data Sync可以同时执行这两项工作，但似乎存在很多限制。我甚至测试了它 与"AdventureWorks"一起使用azure中的数据库示例以及我自己的内部数据库，但是有太多不受支持的表和列，
包括"每个表必须有一个主键"，" 一个表不能有一个不是的标识列primary
key"

I know that Azure Data Sync can do both, but there seems to be a lot of limitation. I even tested it  with the "AdventureWorks" database sample in azure and also my own on premise db but there were too many tables and columns that are unsupported, including "Each table must have a primary key", "A table cannot have an identity column that is not the primary key"

是否已有Azure Data Sync的替代方案？可能在内部复制的东西db

Is there already an alternative for Azure Data Sync? Something that may replicate on premise db

Azure自动化Runbook是否有能力这样做？我正在尝试检查其他文章和论坛，但我似乎找不到我需要的东西。 

Will Azure automation runbook have the capability to do so? I'm trying to check other articles and forums but I can't seem to find what I need. 

推荐答案

你好，



您是否尝试过使用事务复制？

https：// docs。 microsoft.com/en-us/sql/relational-databases/replication/replication-to-sql-database

SQL数据同步的非Microsoft替代方案是SymmetricDS：

http：// www。 symmetricds.org /

要复制Azure SQL数据库，您可以使用TSQL，PowerShell或Azure门户。

CREATE DATABASE db_copy   

   
作为ozabzw7545.db_original的副本（SERVICE_OBJECTIVE ='P2'）;

    AS COPY OF ozabzw7545.db_original ( SERVICE_OBJECTIVE = 'P2' );

New-AzureRmSqlDatabaseCopy -ResourceGroupName" myResourceGroup"`

   
-ServerName

    -ServerName

sourceserver`

sourceserver `

   
-DatabaseName" MySampleDatabase"`

    -DatabaseName "MySampleDatabase" `

   
-CopyResourceGroupName" myResourceGroup"`

    -CopyResourceGroupName "myResourceGroup" `

   
-CopyServerName

    -CopyServerName

targetserver`

targetserver `

   
-CopyDatabaseName" CopyOfMySampleDatabase"

    -CopyDatabaseName "CopyOfMySampleDatabase"

希望这会有所帮助。

问候，

Alberto Morillo

SQLCoffee.com

这篇关于是否已有Azure Data Sync的替代方案？ Azure自动化Runbook / powershell会是一个吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！