Redgate pgCompare

What Redgate pgCompare is

Redgate pgCompare is a database comparison tool for Linux, macOS, and Windows. It compares schemas for a single database engine and can generate migration scripts. The free Community plan is for non-commercial use or qualifying small businesses with under $1 million in annual revenue and fewer than 250 employees. The Standard plan costs $93 a year, billed at $93 per user, per year.

Standard includes schema comparison, deployment script generation, pre-deployment warnings, targeted deployment, and a visual diff interface. Those features support comparing database structures and preparing deployments, including selecting a deployment target and reviewing differences visually. pgCompare’s listed capabilities also include migration scripts. It does not include source control or CI/CD integration. Redgate, the company behind pgCompare, was founded in 1999 and is headquartered in Cambridge, United Kingdom. The product’s single-engine scope makes it relevant to teams working with one database engine across supported operating systems. Community’s eligibility terms distinguish its free use, while Standard adds the listed deployment tools for a per-user annual charge.

Who it suits

pgCompare suits database users who need to compare schemas and prepare migration scripts on Linux, macOS, or Windows. Community may fit non-commercial users or qualifying small businesses, while Standard is for users who need its deployment planning and visual comparison features.

Limits

Community is free only for non-commercial use or qualifying small businesses with under $1 million in annual revenue and fewer than 250 employees. Standard costs $93 a year per user.

Getting started

1. Visit the Redgate pgCompare website.
2. Choose Community if the use is non-commercial or the business meets the listed eligibility terms.
3. Choose Standard at $93 a year per user if its deployment features are needed.
4. Use pgCompare on Linux, macOS, or Windows to compare schemas and prepare migration scripts.

Verdict

Choose pgCompare if you need schema comparison and migration scripts for a single database engine across its supported platforms. Look elsewhere if source control or CI/CD integration is required; Standard also carries a per-user annual charge.