dbForge Data Compare for PostgreSQL | Data Comparison and Synchronization Tool (original) (raw)

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.

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

How to compare databases in PostgreSQL?

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

1. Open the New 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 Data Comparison document, select the data to be synchronized 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.

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)

Leading companies choose dbForge Data Compare

Awards & Recognition

dbForge solutions have been consistently recognized for quality, reliability, and practical value delivered under sleek user interfaces

Try dbForge Studio, a universal PostgreSQL GUI tool

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.