dbForge Schema Compare for PostgreSQL

dbForge Schema Compare for Amazon Redshift and PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool gives a comprehensive view of all differences in Amazon Redshift database schemas and generates clear and accurate SQL synchronization scripts to update the database schemas.

Key features:

1. Supported Databases - Amazon Redshift, Postgre Databases (support is restricted), Amazon RDS for PostgreSQL (support is restricted), Azure PostgreSQL (support is restricted)
2. Supported Schema Objects - Schemas, Tables, Views, Procedures, Functions, Comments.
3. Schema Comparison Result Analysis

• Filter, group and sort object in results
• View DDL differences for each object pair
• Preview the schema update script for each object Synchronization features

4. Synchronization features

• Generate deployment scripts
• Migrate any schema differences
• Dependency check to script objects
• Automatic resolution of sync issues
• Warnings on controversial points prior to sync
• Compare and sync pre-object security permission

5. Non-Schema Object Comparison - Along with database schema objects, the solution allows comparing and synchronizing pre-object security permissions.
6. Code Comparison - The solution allows you to efficiently compare PLPgSQL and Python code.