Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for PostgreSQL logo for PostgreSQL
 
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license
Other tools

Standard Features

The Standard license enables all features of the main GUI application, making your database comparison and synchronization tasks significantly more convenient and productive. The Standard license is also required to use the Linux CLI version on Windows WSL, as well as for automated use of the Linux version by companies and organizations.

Batch Data Diff

Batch data diff allows to compare and synchronize data for multiple tables, views, and custom queries (open the Use Case):

for PostgreSQL, batch data diff

Query Result Diff

Query result diff allows to compare custom query results (open the Use Case):

for PostgreSQL, query result diff

Note that query results can not be merged.

Table Structure Diff

Table structure diff allows to analyze table definition differences and synchronize required changes (open the Use Case):

for PostgreSQL, table structure diff

Diff Profiles

A Diff profile is a set of reusable settings tailored to a specific database project, like HR, inventory, or any other system. It stores custom data comparison and application settings:

  • custom column mappings and key definitions
  • frequently used queries
  • custom batch data diff reports (aka Data slices)

This way, you define the require comparison logic once, then reuse it across dev, staging, and production environments without reconfiguring everything for each database pair.

Id-Remap Merge

Id-Remap Merge allows to merge tables with auto-number primary keys referenced by foreigh keys:

for PostgreSQL, Id-Remap Merge demo

Check the documetnation for scenario examples or watch a series of videos about Id-Remap Merge.

Automation and Scripting

KS DB Merge Tools for PostgreSQL has a built-in scripting language designed to automate the most common diff and merge tasks using the command line. Also it has a special Script Editor application desinged to simplify creation and validation of scripts. See the Use Case.

for PostgreSQL, Script Editor

Other Enhancements

The Standard version also has many other improvements, here are just some of them:

  • More object types
  • More details for table definitions
  • Customize columns and keys mapping
  • General application customization
  • Compare data for Views
  • Export diff results to Xlsx and Json formats
  • Export large SQL synchronization scripts
  • Enhanced diff presentation and changes navigation

The documentation describes limitations for each tab or dialog, and many tools are generally unavailable in the Free version.