• KS DB Merge Tools
• for MS Access
• Standard Version: Features

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.

Batch Data Diff

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

Query Result Diff

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

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):

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.

Automation and Scripting

AccdbMerge 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.

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
• Enhanced diff presentation and changes navigation
• GUI command line support to act as a diff viewer for source control

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