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
- Use pre- and post-synchronization scripts
Automate routine tasks
- Automate schema comparison and synchronization via the command-line interface
- Generate comparison reports 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 dbForge Schema Compare for PostgreSQL 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 available for free.
Detailed information about the dbForge Schema Compare for PostgreSQL functionality is provided on the official page.