apgdiff vs DBDiff

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.

DBDiff compares local or remote databases and creates migration files from their differences. Its drivers support MySQL, PostgreSQL and SQLite, and its schema and data diffing covers tables, views, materialized views, triggers, routines, types, domains, sequences and row-level-security policies. YAML settings and command-line options can include or exclude tables, omit columns, filter rows, and set schema or data scope by table. Migration output includes up and down SQL in native SQL, Flyway, Liquibase XML or YAML, Laravel Migrations and custom templates. A built-in runner offers commands to create, apply, roll back, inspect, validate, repair and baseline migrations. A Supabase option selects PostgreSQL and enables SSL, but limits that diff to the public schema, leaving managed auth and storage schemas out. Pre-built binaries are available for Windows, macOS and Linux without PHP, Node or Composer; PHAR and Composer installs need PHP 8.1 or newer. DBDiff is free, open source under the MIT license.