如何在PostgreSQL中的两个数据库之间比较数据? [英] How to compare data between two databases in PostgreSQL?
本文介绍了如何在PostgreSQL中的两个数据库之间比较数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否可以比较两个具有相同结构的数据库?
假设我有两个数据库DB1和DB2,并且我想检查它们之间的数据是否有差异。
Is it possible to compare two databases with identical structure? Let say that I have two databases DB1 and DB2 and I want to check if there is a difference in data between them.
推荐答案
有几种工具:
(请注意,这些工具大多数只能比较结构,而不能比较数据)
There are several tools out there:
(note that most of these tools can only compare structure, but not data)
免费版:
- pgquarrel: http://eulerto.github.io/pgquarrel
- apgdiff: http://apgdiff.com/
- Liquibase(跨DBMS):< a href = http://www.liquibase.org rel = noreferrer> http://www.liquibase.org
- WbSchemaDiff(跨DBMS): http://www.sql-workbench.net/manual/compare -commands.html
- Migra: https://migra.djrobstep .com /
- pgquarrel: http://eulerto.github.io/pgquarrel
- apgdiff: http://apgdiff.com/
- Liquibase (Cross DBMS): http://www.liquibase.org
- WbSchemaDiff (Cross DBMS): http://www.sql-workbench.net/manual/compare-commands.html
- Migra: https://migra.djrobstep.com/
商业:
- 数据库比较器: http://www.sqlmanager.net/ zh_cn / products / postgresql / dbcomparer
- Aqua Data Studio: http://docs.aquafold.com/docs-diff-schema.html
- DB Solo: http://www.dbsolo.com/index.html (30天试用期)
- PostgresCompare: https://www.postgrescompare.com/
- DB Comparer: http://www.sqlmanager.net/en/products/postgresql/dbcomparer
- Aqua Data Studio: http://docs.aquafold.com/docs-diff-schema.html
- DB Solo: http://www.dbsolo.com/index.html (30 day trial)
- PostgresCompare: https://www.postgrescompare.com/
这篇关于如何在PostgreSQL中的两个数据库之间比较数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文