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.

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.

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.

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

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