数据库差异工具
作为使用 JPA/Hibernate 的 Java 开发人员，我正在寻找一个有助于区分 Hibernate 生成的数据库与生产数据库的工具。
我已经研究过 LiquiBase 的功能LiquiBase，这非常好......不幸的是它受到一些奇怪的困扰bugs:
- 无缘无故重新创建外键
- 无缘无故重新创建索引
我不完全确定这是 Liquibase 的错误，就像 JDBC 驱动程序实现不符合规范一样。如果我什至尝试推出自己的产品，我可能也会受到同样的问题的困扰。
我正在寻找一个非基于 Java 的解决方案，支持：
- MySQL
- PostgreSQL
- Oracle
- DB2
As a Java Developper using JPA/Hibernate, I am looking for a will help diff a database that has been generated by Hibernate with a production database.
I've already looked at LiquiBase's abilities LiquiBase which is quite nice... Unfortunlately it is plagued by some weird bugs:
- Re-Create Foreign Keys for no reason
- Re-Create Indexes for no reason
I'm not entirely sure that it's Liquibase's fault as much as the JDBC Driver Implementation that are not consistent with the specification. I would be probably be plagued by the same issues if I even tried to roll out my own.
I am looking for a non Java-based solution that would support:
- MySQL
- PostgreSQL
- Oracle
- DB2
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我喜欢DB Data Difftective。
I like DB Data Difftective.
你看过 ModelRight 吗？
Have you looked at ModelRight?
如果您只需要比较或“修补”数据值（而不是结构），那么开源 DiffKit 将为您很好地处理这个问题：
http ://www.diffkit.org
If you just need to diff or "patch" data values (not structure), then Open Source DiffKit will handle this nicely for you:
http://www.diffkit.org