PostgreSQL Data Sync and Compare Diffs Tool

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 delivers the generation of 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 9.5 to 14 as well as to Amazon Redshift

Watch the video to get insight into the cutting-edge capabilities of dbForge Data Compare for PostgreSQL that help you perform the comparison and synchronization of PostgreSQL database data with a few simple steps.

Features

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

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.

Flawless data synchronization scripts

  • Auto-generate sync scrips 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 Synchronization

How to compare databases in PostgreSQL?

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

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

How to sync data between PostgreSQL databases?

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

  1. In the comparison result window, select the data to synchronize and click Synchronize data to the target database.
  2. Specify how to output the synchronization script, set synchronization options, and add scripts to be executed before or after data synchronization.
  3. Click Synchronize and see the result.
Learn More

Leading companies choose dbForge Data Compare

Thermo Fisher Scientific
Goodyear
Marriott International
SALESFORCE.COM, INC.
BlackRock Financial Management, Inc.
Halliburton

Need a tool for SQL coding, data editing, and reporting?

Try dbForge Studio, a universal PostgreSQL GUI tool

Find out more

Frequently Asked Questions

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
  • PostgreSQL 8.3
  • Amazon Redshift
What can be compared and synchronized?
  • Tables
  • Views
  • Custom queries
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)
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 results
  • View data differences for each pair of objects
  • Quickly navigate through data differences
  • Perform a full-text search in data
  • View 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 data comparison report in Excel and HTML formats
  • Include actual data into the report
  • Report on selected objects only
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
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

Buy multi-user licenses with a substantial discount

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

Purchase now

Need a hand?

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

How to get a discount on dbForge products

Step 1
Fill in the form
Step 2
Wait for a reply
Step 3
Get a discount
Discount Program
50% OFF