This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Note

: This feature is available in Community, Enterprise, and Ultimate editions only.

Table of contents

• Schema Compare and Changelog
  • Schema Compare
  • Liquibase Changelog
  • Supported databases
  • Objects included in comparison
  • Additional Liquibase resources
• Data Compare
• Simple Structure Compare

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.

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.

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

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:

• how Liquibase works
• core Liquibase usage concepts
• Liquibase PRO get started

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.

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.

See the Simple Structure Compare guide.