apgdiff Free PostgreSQL diff tool useful for schema upgrades
Download

apgdiff Ranking & Summary

apgdiff Tags

compare PostgreSQL PostgreSQL diff schema comparison compare schema diff

apgdiff Description

Free PostgreSQL diff tool useful for schema upgrades apgdiff is a free and Java based platform-independent PostgreSQL diff tool that is useful for schema upgrades. The apgdiff tool compares two schema dump files and creates output file that can be used for upgrade of old schema. Here are some key features of "apgdiff": · apgdiff looks for differences in definitions of TABLEs, SEQUENCEs, CONSTRAINTs, INDEXes, VIEWS, FUNCTIONs and TRIGGERs · apgdiff creates SQL commands for creations, drops and modifications of database objects · CREATE SCHEMA, CREATE TABLE, ALTER TABLE (except ALTER TABLE ... OWNER TO ...), CREATE SEQUENCE, CREATE INDEX, CREATE (OR REPLACE )VIEW, CREATE (OR REPLACE )FUNCTION, CREATE TRIGGER and SET search_path commands are supported but some specific features of the commands may not be implemented yet (see Note below) · Comments, empty lines, SET (except SET search_path), COMMENT, SELECT, INSERT INTO, REVOKE, GRANT and possibly other commands are ignored Requirements: · Java 5 or later

apgdiff Related Software