DbForge Schema Compare for Redshift/PostgreSQL
About
dbForge Schema Compare for PostgreSQL (also fully compatible with Amazon Redshift) is a tool for easy and effective comparison and synchronization of database structure differences. With its help, you can identify and review differences in database schemas and generate SQL scripts to synchronize source and target databases.
Key features:
Compare schemas and analyze comparison results
- Filter, group, and sort objects in results
- View differences in DDL for each object pair
- Preview schema update script for each object
- Generate detailed comparison reports
Deploy comparison results to target databases
- Generate deployment scripts for review or synchronization purposes
- Migrate schema differences (individual, selected, or all)
- Run dependency checks to script objects in the correct order
- Get warnings on possible issues before synchronization
- Resolve sync issues automatically
Supported databases
- Amazon Redshift
- PostgreSQL (limited)
- Amazon RDS for PostgreSQL (limited)
- Azure PostgreSQL (limited)
Supported objects
- Schemas
- Tables
- Views
- Procedures
- Functions
- Comments
- Materialized views
Additionally, you can compare and synchronize pre-object security permissions as well as PL/pgSQL and Python code.
Use Schema Compare on Windows, Linux, and macOS
Schema Compare is available on Windows, Linux, and macOS; to use it on the latter two platforms, you need to download and install a special compatibility solution called CodeWeavers CrossOver.
Learn more
dbForge Schema Compare for PostgreSQL is a completely free product; feel free to download it here.
To learn more about Schema Compare, please visit this page.