DEV Community

andreasneuman
andreasneuman

Posted on

1

Compare and Sync PostgreSQL & Amazon Redshift Databases

dbForge Schema Compare for Redshift/PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool is best suited when you need to compare Amazon Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

The new solution also has such key features as:

  1. Support for Amazon Redshift. The first version features Amazon Redshift support to compare and synchronize database schemas.

  2. Limited Support for PostgreSQL. At the moment, the vendor also implemented the limited support for the following PostgreSQL databases: PostgreSQL, Amazon RDS for PostgreSQL, Azure PostgreSQL.

  3. Support for Redshift Objects. The solution allows users to compare and sync the following Redshift objects: Schemas, Tables, Views, Function, Procedures, Comments, Privileges.

  4. Identification of Object Dependencies. The tool allows users to sync objects they have not selected for synchronization but which are used by objects they added to synchronize.

  5. Review of DDL Differences in Database Objects. Also, users can view DDL differences for each object pair to analyze the schema comparison result.

  6. Execution of Query History. Users can get basic information about PostgreSQL queries executed in the database for a certain period of time.

  7. Execution of Large Script. The large scripts can be executed without opening in the editor.

Image of Datadog

Create and maintain end-to-end frontend tests

Learn best practices on creating frontend tests, testing on-premise apps, integrating tests into your CI/CD pipeline, and using Datadog’s testing tunnel.

Download The Guide

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more