如何同步位于不同主机的DB2数据库/表? [英] How to sync DB2 databases/tables located on different hosts?
问题描述
我们可以使用什么样的策略来同步位于不同主机上的DB2数据库和/或表?
What kind of strategy we could use to sync DB2 database and/or tables located on different hosts?
我正在寻找一种策略,我可以配置一些参数(如主机,端口等),只需要写一个表名。之后,工具,脚本或其他策略应该同步这些表跨主机。
I'm searching for a strategy that I could configure some parameters (like host, port, etc.) and just write a table name. After this the tool, script, or other strategy, should sync the tables cross the hosts.
对于MySQL我知道一个这样做的工具( pt-table-sync )。但是,我们可以为DB2做什么?
For MySQL I know a tool that do something like this (pt-table-sync). But, what we can do for DB2?
如果是一个工具,重要的是它是一个免费的。
If is a tool, would be important that it is a free one.
推荐答案
SymmetricDS 是用于同步数据库的开源Java工具。它还支持DB2和各种其他异构SQL复制。
SymmetricDS is an open source java tool for synchronizing databases. It supports DB2 and a variety of others for Heterogeneous SQL Replication as well.
这篇关于如何同步位于不同主机的DB2数据库/表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!