apgdiff vs SQL Delta
apgdiff
github.comSQL Delta
sqldelta.comSide by side
| Figure | apgdiff | SQL Delta |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | — |
| Plans published | 1 | 10 |
| Spec score · Database Schema Comparison Tools | 8.2 (#5) | 8.1 (#6) |
| Founded | 2006 | 1991 |
| Purpose | apgdiff compares two PostgreSQL database schema dump files and outputs DDL statements to update the old schema or show the differences. | SQL Delta compares database schemas and data so teams can review drift and synchronize changes before deployment. |
| Support | The site directs users to GitHub Issues to report bugs or request features and lists the author’s email for comments and suggestions. | Customers can contact the company by email for SQL Delta support and access its support portal. |
Plans
SQL Delta
- SQL Delta for MySQL — Single license$185, paid once
- SQL Delta for Oracle — Single license$370, paid once
- SQL Delta for SQL Server — Single license$370, paid once
- SQL Delta for MySQL — 5 Licenses$510, paid once
- SQL Delta for MySQL — 10 Licenses$920, paid once
- SQL Delta for Oracle — 5 Licenses$1,020, paid once
- SQL Delta for SQL Server — 5 Licenses$1,020, paid once
- SQL Delta for MySQL — Site License$1,395, paid once
- SQL Delta for SQL Server — 10 Licenses$1,850, paid once
- SQL Delta for SQL Server — Site License$2,775, paid once
In their own words
apgdiff
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.
SQL Delta
SQL Delta is a Windows tool for comparing database schemas and data before changes reach production. SQL Delta 7 compares source and target databases that use the same server type; SQL DXP is intended for comparisons across different server types. Schema Compare shows structural differences in live databases or snapshots and lets users select what to include in a deployment script. Data Compare identifies row-level differences between environments. Users can review and edit synchronization scripts before executing them against a target, and projects can add custom script to deployment scripts. SQL Delta can save HTML reports and XML snapshots for release reviews or recovery work. Project completion events and command-line execution support automated runs. Editions are listed for SQL Server, MySQL, Oracle, and PostgreSQL. A separate Read Only Edition allows comparison and script generation but prevents direct script execution. The latest full product download has a 14-day trial. The MySQL single-license plan is $185 as a one-time purchase and includes a two-year software update subscription; purchase terms also describe a perpetual license.