apgdiff vs DBC

apgdiff is a free command-line tool that compares two PostgreSQL schema dump files and generates DDL statements to update an older schema or show differences. It takes an original dump and a new dump as inputs; generated SQL can be printed in the terminal or redirected to a file. The project says it can be called from batch jobs or web applications. It is written in Java and requires Java 1.6 or newer. Listed systems include Windows, Linux, Mac OS X, Solaris, and BSD, as well as other systems where Java is available. Version 2.4 is identified as the latest stable release, with binary and source ZIP downloads. Support covers selected ALTER SEQUENCE, ALTER TABLE, ALTER VIEW, COMMENT, CREATE FUNCTION, CREATE INDEX, CREATE SCHEMA, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE VIEW, and SET search_path statements. Other SQL statements are ignored, and an option reports ignored DDL. For CREATE TABLE column constraints, only NULL and NOT NULL are supported. The project uses the MIT License and recommends reviewing generated upgrade SQL before applying it.

DBC is a free, open-source command-line tool for comparing database schemas across versions, environments, or database systems. Built with Go, it captures schema snapshots and checks tables, columns, indexes, foreign keys, and constraints for changes. It supports MySQL, PostgreSQL, SQL Server, Oracle, and SQLite. Optional data checksums can reveal data modifications, while exact row counts are enabled by default. Results can be output as text, JSON, or HTML. Database drivers run as separate executables and communicate with the core application over JSON-RPC through standard input and output; the README notes that drivers use timeouts but makes no certification or compliance claim. Building the core and drivers from source with Make is the documented installation route. DBC is licensed under MIT and is listed for Linux, macOS, and Windows. The releases page lists v0.1.0-alpha as a pre-release. CI/CD examples, Docker support, migration script generation, and a web UI appear on the roadmap, not among the available features.