不同的数据库复制(不同类型的 RDBMS 之间)
我正在寻找能够在不同数据库系统之间进行复制的产品的推荐。我们只是在寻找标准复制(将此表复制到此处并在事务发生时应用它们) - 没什么花哨的。
我们无法使用内置数据库复制,因为我们的源服务器(Tandem/NSK)根本不支持任何类型的推送复制。我们一直在使用 GoldenGate (http://www.goldengate.com/),但我对那里的其他选择感兴趣。如果重要的话,目标服务器是 MSSQL 框。
我知道它会很贵,所以我不仅仅对免费产品感兴趣,而且我更喜欢有专业支持的东西。如果您对 GoldenGate 这样的产品有一定的经验,我很想听听,因为我想市场上一定还有其他产品可以完成 GoldenGate 的功能。
I'm looking for a recommendation for a product that enables replication between different database systems. We're just looking for standard replication (copy this table over here and apply transactions as they happen) - nothing fancy.
We can't use built-in database replication because our source server (Tandem/NSK) doesn't support any kind of push replication at all. We've been using GoldenGate (http://www.goldengate.com/), but I'm interested in other choices out there. If it matters, out destination server is an MSSQL box.
I know it gets expensive, so I'm not just interested in free products, and I'd prefer something with professional support. If you have some experience with a product like GoldenGate, I'd love to hear it, as I imagine there have to be other products on the market that do what GoldenGate does.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
SymmetricDS 可能是您感兴趣的解决方案。它同步不同类型的 RDBMS,但它确实使用数据库触发器,并且是基于Java。它是为更多的高度分布式和可能断开连接的环境而构建的,但适用于点对点类型的复制。
SymmetricDS might be a solution you would be interested in. It synchronizes different types of RDBMSs, but it does use database triggers and is Java based. It was built for more of a highly distributed and possible disconnected environment, but would work for point to point type replication.