如何同步SQLServer数据库和MySQL数据库 [英] How to Synchronize SQLServer Database and MySQL Database

问题描述

我的场景:

我有两个申请.第一个是连接到MySQL数据库的网站，第二个是连接到SQL Server2008 R2数据库的桌面应用程序. 桌面应用程序在本地更新记录，而MySQL数据库通过网站在线更新.

I have two applications. First one is a website which is connected to MySQL Database and 2nd one is a Desktop Application which is connected to SQL Server2008 R2 Database. The Desktop application updates records locally and the MySQL database is updated online though the website.

问题:

两个不同的数据库，当在MySQL或SQL数据库中进行更改时，如何在现场进行更新?

Two different databases, how can we update at the spot when changes are made either in MySQL or SQL Database?

我想要什么:

数据库应彼此同步(例如，如果在MySQL中进行了更改，则应更新SQL Server数据库，或者如果在SQL数据库中进行了更改，则应更新MySQL数据库)

Databases should be synchronized to each other (e.g. if changes are made in MySQL then SQL server database should be updated, or if changes are made in SQL Database then MySQL database should be updated)

有人可以建议一些代码，任何想法或任何解决方案来解决此问题吗?

Could anybody please suggest some code, any idea, or any solution to solve this issue?

推荐答案

利用Restful API将信息从MS SQL服务器更新到MYSQL服务器.

Make use of Restful API's to Update information from MS SQL server to MYSQL server.

这篇关于如何同步SQLServer数据库和MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！