Structure and data compare
Note
This feature is available in Community, Enterprise, Ultimate and Team editions only.
DBeaver provides tools to compare database structures and data and to track changes. You can use Schema Compare to review schema differences in detail, Liquibase Changelog to generate changelogs, Data Compare to compare table data or query results, and Simple Structure Compare for quick object-level checks.
Schema Compare and Changelog¶
Schema Compare¶
Schema Compare shows the differences between two database structures. It highlights changes in a clean diff view and generates scripts to align one side with the other.
Info
See Schema Compare guide.
Liquibase Changelog¶
Changelog generation creates a snapshot of selected containers or objects. It outputs a Liquibase Changelog with creation statements for tables, views, keys, sequences, and other metadata.
Info
See Liquibase Changelog guide.
Supported databases¶
Schema Compare and Liquibase Changelog works with any JDBC-compatible database that Liquibase supports.
Both features have been tested with the databases below and work reliably with them:
| Database | Database |
|---|---|
| CockroachDB | Oracle |
| Databricks | PostgreSQL |
| DB2 | Redshift |
| Derby | SAP HANA |
| EnterpriseDB | Snowflake |
| Firebird | SQLite |
| Greenplum | SQL Server |
| Informix | Teradata |
| MySQL/MariaDB | Vertica |
| Netezza | YugabyteDB |
| DB2i |
Note
Some databases, such as SQLite and Firebird, don’t use catalogs or schemas. In those cases, the entire datasource is compared as a single unit.
Objects included in comparison¶
Most databases let you compare core structural objects, such as:
- tables
- views
- columns
- primary keys
- foreign keys
- indexes
- sequences
- unique constraints
Info
With Liquibase PRO, you can work with extended metadata. For details, see the Liquibase PRO guide.
Additional Liquibase resources¶
For more information on Liquibase, refer to:
Data Compare¶
Data Compare checks differences between two tables or two query results. It helps you spot changes in rows and values, navigate differences quickly, and generate SQL scripts to sync data between sources.
Info
See the Data Compare guide.
Simple Structure Compare¶
Simple Structure Compare compares two individual objects side by side. It works as a lightweight, built-in tool for reading metadata, exploring child nodes, and highlighting differences in tables, columns, keys, indexes, and other structural elements.
Info
See the Simple Structure Compare guide.