Azure Scheduler，用于更新Azure和On Premise SQL Server数据库 [英] Azure Scheduler that updates Azure and On Premise SQL Server Database

问题描述

Hello All，

Hello All,

我有一个REST服务需要将数据更新到Azure SQL Server数据库以及On Premise SQL Server数据库。两个数据库在某些数据库表中应该具有相同的数据。

I have a REST Service that needs to update data into Azure SQL Server database and also into On Premise SQL Server database. Both databases should have same data in certain database tables.

调度在Azure中运行的服务，并将数据传输到Azure数据库，然后进入On Premise数据库，例如：每隔5分钟就可以了。还有其他技术，例如REST更新Azure数据库，然后更新On Premise数据库。

Scheduling Service that runs in Azure and process data transfer into Azure Database and then into On Premise database e.g. after every 5 minutes is okay. Also other techniques too e.g. REST updating both Azure database and then On Premise database.

使用这些Azure技术，使用C＃进行配置和编程，我很新。

I'm quite new using these Azure techniques using both configurations and programming with C#.

我已阅读有关功能应用，Azure数据工厂，Azure逻辑应用和同步的信息，但不知道将数据从Azure传输到Azure数据库然后在On Premise数据库中可以使用哪种技术。

I have read about Function Apps, Azure Data Factory, Azure Logic Apps and Synchronizations but don't know what technique is ok to transfer data from Azure to Azure database and then On Premise database.

你是如何解决这类问题的？

How have you solved this kind of issue?

祝你好运，

Michael

推荐答案

迈克尔， 

Hi Michael, 

感谢您的光临。查看我们关于
SQL数据同步以及设置
混合连接。我希望你觉得这有帮助。如果没有，请随时联系我们。

Thanks for you reaching out. Have a look at our documentation on SQL data sync as well as setting up a hybrid connection. I hope you find this helpful. If not, please feel free to reach back out to us.

这篇关于Azure Scheduler，用于更新Azure和On Premise SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！