Compare Diffs and Sync Table Data in PostgreSQL

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. This PostgreSQL compare tool helps to custom-tailor the detection of data differences between two PostgreSQL tables, and establish smart management, and safe deployment of table data inconsistencies. The PostgreSQL diff tool also delivers the generation of the PostgreSQL data synchronization scripts with multiple options to keep 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 with help of command-line interface
  • Deploy to PostgreSQL from 9.5 to 12 as well as to Amazon Redshift
Features

Explore differences between two databases

Comparison results are neatly displayed in a convenient UI that makes the analysis of PostgreSQL table data diffs easy and smooth. The tool allows customizing data diffs display by:

  • Object type (objects with different or identical records).
  • Object origin (Source or Target).
dbForge Data Compare for PostgreSQL - data diffs between two Postgres databases

Compare inconsistent data

The 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 structure.

Compare tables with different structure

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.

Custom PostrgeSQL query comparison

Accurate comparison reports

  • Present the results of PostgreSQL data as a handy comparison report for neat presentation of the comparison results
  • Report formats (Excel, HTML)
  • Customize the set of comparison data to be included to a report
Generate comparison report

Full or partial table data sync

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

Full and paritaSynchronize PostgrgreSQL table data in whole or in part

Flawless data synchronization scripts

  • Automatic generation of sync scrips to eliminate PostgreSQL data inconsistencies
  • Execute the generated script to immediately deploy table data changes
  • Save the script to a file to sync tables between databases afterwards
PostgeSQL data synchronization script

Data comparison automation

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

  • Saving comparison project for the future use
  • Saving comparison settings to a command line arguments file
  • Using command line interface for automatic routine synchronizations
  • Creation of a command line execution file (.bat) and run it with Command Prompt or PowerShell
  • Scheduling database data comparison with Windows Task Scheduler
PostgreSQL data comparison austomation

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

Try dbForge Studio, a universal PostgreSQL GUI tool.

Find out more

Get started with Data Compare for PostgreSQL at no cost

Download a FREE 30-day trial version and start saving time spent on your database deployments today.

Download free

Buy multi-user licenses with substantial discount

We provide flexible purchase options, including bulk discounts, to meet the need and budget of each and 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.

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.