Meet dbForge Schema Compare for PostgreSQL, v1.0!

September 4th, 2020

We are proud to announce the release of a new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL, v1.0.

The tool is best suited when you need to compare Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

Support for Amazon Redshift

In this version, we supported Amazon Redshift to compare and synchronize database schemas:

Support for Amazon Redshift

Limited Support for PostgreSQL

We have implemented the limited support for the following PostgreSQL databases you can use as a source and a target database to compare and synchronize database schemas:

  • PostgreSQL Databases
  • Amazon RDS for PostgreSQL
  • Azure PostgreSQL
Support for PostgreSQL

Support for Redshift Objects

You can compare and sync the following Redshift objects:

  • Schemas
  • Tables
  • Views
  • Function
  • Procedures
  • Comments
  • Privileges
Synchronizing Redshift objects

Identification of Object Dependencies

The tool allows you to sync objects that you have not selected for synchronization but they have been used by objects you added to synchronize.

Identifying object dependencies

Review of DDL Differences in Database Objects

You can view DDL differences for each object pair to analyze the schema comparison result.

View DDL differences in database objects

Execution of Query History

You can view basic information about PostgreSQL queries executed in the database for a certain period of time.

Query History Execution

Execution of Large Script

You can execute large scripts without opening them in the editor.

Large script execution

Share Your Feedback with Us

Download the first version of dbForge Schema Compare for PostgreSQL and share your thoughts with us!

For more information about the tools that will help you improve PostgreSQL database development, navigate to dbForge for PostgreSQL.

Leave a Comment