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 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 table 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