apgdiff vs DTM Schema Comparer
apgdiff
github.comDTM Schema Comparer
sqledit.comSide by side
| Figure | apgdiff | DTM Schema Comparer |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | — |
| Plans published | 1 | 2 |
| Spec score · Database Schema Comparison Tools | 8.2 (#5) | 7.8 (#9) |
| Purpose | apgdiff compares two PostgreSQL database schema dump files and outputs DDL statements to update the old schema or show the differences. | DTM Schema Comparer compares and synchronizes database schemas, including tables, columns, views, indexes, triggers, keys, comments and stored procedures. |
| Support | The site directs users to GitHub Issues to report bugs or request features and lists the author’s email for comments and suggestions. | DTM soft technical support may request ERROR.LOG files for technical purposes and says the information is not provided to third parties. |
Plans
DTM Schema Comparer
- Standard$179, paid once
- Professional$249, 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.
DTM Schema Comparer
DTM Schema Comparer has no write-up on Specifiction yet; its figures are above.