pgCompare

pgCompare Standard offers additional features not included within the community edition, which include:

Features & Editions	Community	Standard*	Flyway Enterprise
Graphical User Interface	✅	✅	✅
Dependency Ordering	✅	✅	✅
Data Source: Database	✅	✅	✅
Data Source: Snapshots		✅*	✅(CLI)
Comparison options: detect renames		✅*	✅
Comparison options: ignore newlines		✅*	✅
Filter File compatibility		✅*	✅
Deployment Warnings**		✅*	✅
Support for older versions of PostgreSQL		✅	✅
Export comparison report		✅*	✅
Drift checks			✅
Schema model support			✅
Command Line Usage			✅
Database DevOps Capabilities Integrate with your existing Git, CI, and CD systems for repeatable and reliable releases (find out more)			✅

*These are future Roadmap Items and not available at the moment, please contact adam.britt@red-gate.com for more details if you are interested in these items

**Deployment Warnings

StaticDataNotDeployed: "Table {tableName} is linked to static data on one side of your comparison but not the other. The static data will not be deployed to avoid possible data loss."
DecompressData: "This deployment disables the compression settings on the hypertable {table}. This will potentially increase the size of the data within the hypertable."
Rebuild: "This deployment rebuilds the {ObjectType} {ToDrop} {reasons}."
ColumnDrop: "This deployment drops the column {toDrop} on table {tableName}. Any data in the column will be lost."
TableDrop: "This deployment drops the table {toDrop}. Any data in the table will be lost."
ColumnNotNullNoDefault: "This deployment alters the column {columnName} on table {tableName} to NOT NULL. Any NULLs in the column will cause the deployment to fail."
FallibleExplicitTypeCast: "Explicit casts are required for the type change on the column {name} on table {TableName}. The deployment script may fail if the cast is not possible."

pgCompare

pgCompare Features