DbForge Data Compare for PostgreSQL

From PostgreSQL wiki
Jump to navigationJump to search

About

dbForge Data Compare for PostgreSQL is a tool that makes table data comparison and synchronization nearly effortless. It is designed to help you quickly detect differences in table data, review and analyze them, and generate scripts to synchronize the content of source and target databases.

Key Features:

Explore the differences between two databases

  • The clean UI and intuitive wizards make it easy to review and analyze comparison results.
  • You can customize the viewing and management of differences to your liking and select what objects are to be shown in the results.

Compare tables with different structures

  • Data Compare automatically maps the objects that you want to compare: tables, views, columns, and schemas.
  • You can modify the default mapping to map tables with different names and structures.

Compare custom queries

  • You can compare an actual table with a custom query execution result.
  • A WHERE clause can be specified to exclude unwanted rows from the comparison.

Generate comparison reports

  • Data Compare helps you create comprehensive reports that showcase the differences in your data.
  • Comparison reports can be generated in CSV, XLS, and HTML.

Synchronize table data fully or partially

  • You can use the grid with the comparison results to select the data that must be synchronized to the target database.
  • A handy wizard will help you configure the output and options.
  • A sync script will be generated in a split second. You can execute it immediately or save it to a file.

Automate data synchronization

  • You can use Windows Task Scheduler to create and manage synchronization tasks that your computer will run automatically at the specified time.

Run Data Compare on different operating systems

  • The product is available on Windows, Linux, and macOS; the latter two options are enabled via a special compatibility solution called CodeWeavers CrossOver.

Learn more

dbForge Data Compare for PostgreSQL comes with a free 30-day trial; feel free to download it here.

To learn more about Data Compare, please this page.

Retrieved from "https://wiki.postgresql.org/index.php?title=DbForge_Data_Compare_for_PostgreSQL&oldid=37619"