DbForge Schema Compare for Redshift/PostgreSQL

From PostgreSQL wiki
Jump to navigationJump to search

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.