将Microsoft SQL复制到其他数据库 [英] Replicate Microsoft SQL to other databases

问题描述

我希望能够将整个数据库从Microsoft SQL复制到另一个对Web友好的数据库，例如CouchDB甚至mySQL.

I'd like to be able to replicate an entire database from Microsoft SQL to another web friendly database such as CouchDB or even mySQL.

我需要每天进行复制，只是想知道是否有可能，如果可以的话，我将如何用最少的编码来完成复制.

I'd need to do replication daily and was just wondering if it's possible and if so, how would I do it with the least amount of coding.

谢谢

推荐答案

使用开放源 SymmetricDS 可以实现可以在不同数据库之间复制更改的解决方案，例如SQL-Server和MySQL.一些功能是:

It's possible with SymmetricDS, an open source solution that can replicate changes between different databases, like SQL-Server and MySQL. Some features are:

• 使用更改数据捕获和连续同步
• 通过基于Web的协议进行低带宽传输
• 后台异步操作
• 从网络停机时间自动恢复

它具有初始加载功能，可让您的数据库保持同步，然后在捕获更改时不断发送更改.有很多配置选项，因此您可以设置同步的频率.

It has an initial load feature to get your databases in sync, then it continuously sends changes as they are captured. There are a lot of configuration options, so you can set how often it syncs.

这篇关于将Microsoft SQL复制到其他数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！