About dbForge Data Compare for PostgreSQL

Compare and sync table data in PostgreSQL.

dbForge Data Compare for PostgreSQL is a tool for table data comparison and synchronization. You can also generate data synchronization scripts and execute them to eliminate differences. Comparison results are displayed in a convenient UI and it's easy to review differences and perform further analysis and synchronization. You can also select which objects to show and how they will be shown.

dbForge Data Compare for PostgreSQL Features

  • Identify the differences between two databases.
  • Compare separate tables or table groups.
  • Compare tables with different structures.
  • Generate reports and save them for further analysis.
  • Synchronize data in tables and views.
  • Generate SQL scripts for database synchronization.
  • Organize database synchronization according to a schedule.

Explore the differences between two databases
Comparison results are displayed in a convenient UI and it's easy to review differences and perform further analysis and synchronization. You can also select which objects to show and how they will be shown.

Compare tables with different structures
Automatically map objects that you want to compare including tables, views, columns and schemas. You can change the default mapping to map tables with different names and structure.

Custom query comparison
Specify a WHERE clause to prevent undesired rows being compared.

Generate comparison reports
View data comparison results in Excel or HTML.

Generate synchronization script
Automatically generate errorless synchronization scripts. You can use these scripts to synchronize databases.

Schedule database comparison
Use Windows Task Scheduler to create and manage synchronization tasks that your computer will carry out automatically at the times you specify.