Data comparison setup

Include tables or views into comparison by mask or individually. Exclude objects from comparison by mask or individually. Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables). Float types rounding option. Ignore Case and Ignore Trailing Spaces options for string comparison. LOB comparison options. WHERE filter for limiting data that needs to be compared (e.g. in extra-large tables).

PostgreSQL Data Sync and Compare Diffs Tool

Q: What servers are supported?

Heroku IBM Cloud Amazon Redshift Amazon RDS Amazon Aurora Azure PostgreSQL PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 PostgreSQL 9.3 PostgreSQL 9.2 PostgreSQL 9.1 PostgreSQL 9.0 PostgreSQL 8.4 Amazon Redshift

Q: How can I analyze comparison results?

Filter and sort objects in results. View data differences for each pair of objects. Quickly navigate through data differences. Perform a full-text search in data. View the number of changes per column. Hide unmodified columns, and lock/unlock the key columns to simplify the analysis. Select arbitrary columns for display.

Q: How can I export data comparison results?

Generate data comparison report in Excel and HTML formats. Include actual data into the report. Report on selected objects only.

Q: Synchronization features

Create accurate synchronization scripts. Migrate individual records, groups of records, or all data differences. Toggle synchronization direction to apply data changes to both databases. Warnings on possible problems prior to synchronization.

Q: How can I automate my routine tasks?

Save comparison project settings for future use. Use command-line interface for automatic routine synchronizations.

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. It helps to custom-tailor the detection of data differences between two PostgreSQL tables, establish smart management of inconsistencies and safe deployment of changes. This PostgreSQL diff tool also generates the PostgreSQL data synchronization scripts with multiple options to keep your PostgreSQL data in sync.

Save time comparing and synchronizing PostgreSQL database data
Generate SQL scripts to update one database with the contents of another
Copy lookup data from development databases to staging or production
Keep an accurate history of all previous PostgreSQL database records
Fix problems by restoring missing or damaged data to a single row
Automate synchronization tasks via the command-line interface
Deploy to PostgreSQL from 8.4 to 17 as well as to Amazon Redshift

Quick start with Data Compare for PostgreSQL

Watch the video to get insight into the cutting-edge capabilities of dbForge Data Compare for PostgreSQL, which will help you compare and synchronize PostgreSQL database data with a few simple steps.

Features

Full or partial PostgreSQL data sync

Simply select the data to be synchronized in the grid with your comparison results. Set the output options to manage your synchronization script and click Synchronize. The script will appear in a split second.

Explore differences between two databases

Comparison results are neatly displayed in a convenient UI that makes the analysis of PostgreSQL table data differences easy and smooth. These differences can be viewed by:

Object type (objects with different or identical records)
Object origin (Source or Target)

Compare inconsistent data

The PostgreSQL diff tool automatically maps the compared objects, including tables, views, columns, and schemas. The default object mapping can also be customized to map the tables with different names and structures.

Custom query comparison

You can compare an actual table with its query result. You may also specify a WHERE clause expression to prevent the comparison of unwanted rows.

Accurate comparison reports

Present the results of PostgreSQL data comparison in a report for convenient presentation
Use different report formats (Excel, HTML)
Customize the sets of comparison data to be included in your reports

Flawless data synchronization scripts

Auto-generate sync scripts to eliminate PostgreSQL data inconsistencies
Execute generated scripts to deploy table data changes immediately
Save your scripts to files to sync tables between databases later

Data comparison automation

The tool provides a variety of options to save time on routine PostgreSQL data diffs management:

Save comparison projects for future use
Save comparison settings to a command-line arguments file
Use the command-line interface for automated routine synchronization
Create a command-line execution file (.bat) and run it via Command Prompt or PowerShell
Schedule data comparison via Windows Task Scheduler

Data Comparison
Data Synchronization

How to compare databases in PostgreSQL?

The PostgreSQL data compare tool can help you compare PostgreSQL tables much faster and easier.

Open the New Data Comparison wizard by clicking New Data Comparison on the standard toolbar.
Select source and target connections and databases, and specify additional options for comparison.
Click Compare. dbForge Data Compare will notify you when the process is completed.

Learn More

Sync Data in the Data Synchronization wizard

How to sync data between PostgreSQL databases?

Follow the instructions in the Data Synchronization wizard to efficiently synchronize data.

In the Data Comparison document, select the data to be synchronized and click Synchronize data to the target database.
Specify how to output the synchronization script, set synchronization options, and add scripts to be executed before or after data synchronization.
Click Synchronize and see the result.

Learn More

System Requirements

Windows

dbForge Studio for PostgreSQL is compatible with Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, as well as with the newest Windows 11

Linux

dbForge Studio for PostgreSQL is now available for the following Linux distributions: Ubuntu, Debian, Fedora, and also Red Hat Enterprise Linux (RHEL)

macOS

You can run dbForge Studio for PostgreSQL on macOS 12 (Monterey), macOS 11 (Big Sur), macOS 10.15 (Catalina), macOS 10.14 (Mojave), and macOS 10.13 (High Sierra)

Get free trial

Leading companies choose dbForge Data Compare

Frequently Asked Questions

What servers are supported?

PostgreSQL 17
PostgreSQL 16
PostgreSQL 15
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
PostgreSQL 11
PostgreSQL 10
PostgreSQL 9
PostgreSQL 8.4
Greenplum DB
Fujitsu Enterprise Postgres
Supabase
Google Cloud
Amazon Redshift
Amazon RDS
Alibaba Cloud
Heroku
TimescaleDB
Amazon Aurora
ElephantSQL
Azure Database for PostgreSQL
AlloyDB
Neon.tech
YugabyteDB
Cloud Native PostgreSQL
PolarDB
AnalyticDB
Citus Data
Aiven Cloud
Bit.io
Azure Cosmos DB for PostgreSQL Cluster
DigitalOcean's Managed Databases
EDB BigAnimal
IBM Cloud for PostgreSQL
Babelfish for Aurora PostgreSQL
ApsaraDB RDS

What can be compared and synchronized?

Tables
Views
Custom queries

How can data comparison be set up?

Include tables or views into comparison by mask or individually
Exclude objects from comparison by mask or individually
Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables)
Float types rounding option
Ignore Case and Ignore Trailing Spaces options for string comparison
LOB comparison options
WHERE filter for limiting data that needs to be compared (e.g. in extra large tables)

How can I compare data in two databases with different structures?

User mapping feature allows comparing tables with different names and column set
Map one table in source with two or more tables in target (useful when the table was split)
Custom Query feature allows comparing a table with a query result

How can I analyze comparison results?

Filter and sort objects in the results
View data differences for each pair of objects
Quickly navigate through data differences
Perform a full-text search in data
View the number of changes per column
Hide unmodified columns and lock/unlock the key columns to simplify the analysis
Select arbitrary columns for display

How can I export data comparison results?

Generate a data comparison report in Excel and HTML formats
Include actual data in the report
Report on selected objects only

What synchronization features does the data comparison tool have?

Create accurate synchronization scripts
Migrate individual records, groups of records, or all data differences
Toggle synchronization direction to apply data changes to both databases
Warnings on possible problems before synchronization

How can I automate my routine tasks?

Save comparison project settings for future use
Use command-line interface for automatic routine synchronizations

Get started with Data Compare for PostgreSQL at no cost

Download a FREE 30-day trial version and start saving time on your data comparison and synchronization tasks today.

Download free

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with us.

Ordering FAQ

[email protected]

Buy multiple licenses with a substantial discount

We give flexible purchase options, including bulk discounts, to meet the needs and budget of every customer.

Start from: $89.95

Purchase now