KS DB Merge Tools
 
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
and MariaDB
for SQLite
 

What's New

1.6.2, 2022-01-07
- Free & Pro: Fix script generation and data diff/merge for tables which were defined with column names wrapped with single-quotes
- Pro: Batch data diff, table name click - open Table structure diff (instead of text diff)
- Pro: Data diff, 'Compare definition' for tables - open Table structure diff (instead of text diff)
1.6.1, 2021-12-20
- Free & Pro: Activation dialog - allow to configure 'check for updates', updated some information
- Pro: Table structure diff tab - fix nullref error on 'Compare data (new and changed)'
- Pro: 'Open protected' dialog - remove System.Data.SQLite options which are no longer supported
1.6.0, 2021-12-18
- Free & Pro: System.Data.SQLite library updated to 1.0.115.5 with support of SQLite 3.37.0 (this library is used to handle non-protected files)
- Free & Pro: Use normalized CREATE TABLE script generated by application instead of provided by SQLite metadata
- Free & Pro: Check for updates
- Free & Pro: Refresh action, applicable for Project, Object list and Data diff tabs
- Free & Pro: Text diff - 'Ignore empty line' option
- Pro: Table structure diff tab
- Pro: Copy to clipboard action, applicable for Project, Object list, Data diff, Query result diff and Text diff tabs
- Pro: Discontinued support of System.Data.SQLite protection type (see details)
- Pro: Object list text diff preview - fix disappearing scrollbar issue
1.5.1, 2021-08-10
- Pro: Batch data diff - fix missing scroll background update on subsequent Run executions
- Pro: Text diff - bottom panel on changed line - non-text area - revert to white backbround color (instead of system control color)
- Free: Execute data merge script dialog - hidden record count and first/last buttons (Free version should not provide any data changes summary)
1.5.0, 2021-08-03
- Free & Pro: Tab toolbar actions moved inside tab, into the panel splitter
- Free & Pro: More usage of system control background color
- Free & Pro: Fix db loading errors caused by using object name quotes inside name
- Free & Pro: Object list - fix no action on object delete if only one side loaded
- Free & Pro: Enable legacyUnhandledExceptionPolicy to avoid crash after background thread error
- Free & Pro: Handle open help page failure
- Free & Pro: Improve settings stability by using read/write retry attempts
- Free & Pro: Referenced Microsoft.Data.Sqlite version increased from 3.1.3 to 3.1.9
- Pro: 'Normalize object name quotes' settings option
- Pro: Project tab - Show all/new/changed actions supported
- Pro: Query result diff - fix broken Excel export
- Pro: Fix unknown error on opening invalid *.sqlts file
1.4.7, 2021-05-21
- Free & Pro: Updated instanceId algorithm to reduce collisions on trial registrations
1.4.6, 2021-05-19
- Free & Pro: Toolbar - showing tooltips on disabled buttons, with disable reason
- Free & Pro: Increase row heights of some grids (to be the same as for data diff)
- Pro: Fix visually disappearing indexes and triggers after table merge/delete
1.4.5, 2021-02-26
- Free & Pro: Fix app start failure caused by FIPS
- Pro: Custom data diff - fix failure caused by mapping duplicates
- Pro: Query result diff - combine execution errors into one, if any
1.4.4, 2021-02-20
- Free & Pro: Data merge - fix SQL formatting for double data type for regions with comma as decimal separator
- Free & Pro: Project reload dialog simplified
- Pro: Query result diff - fix some key field mapping and sorting issues
1.4.3, 2021-02-05
- Free & Pro: Data diff - fixed 'index out of range' error for some cases when compared tables have different number of columns and there are new rows
- Free & Pro: License activation dialog - minor help text updates
1.4.2, 2020-12-10
- Free & Pro: Data diff - fixed column headers truncated text for 100% windows scaling
1.4.1, 2020-12-08
- Free & Pro: Apply OS visual styles for data diff grids, which can also fix potential AccessViolation errors related to tooltips
- Pro: Ability to delete and merge table definitions (MERGE NEW ONLY)
- Pro: Data diff - updated layout for 'No comparison key(s)' and 'Sorting on non-key column(s)' result warnings
1.4.0, 2020-11-10
- Free & Pro: New instanceId algorithm (to reduce collisions), updated trial activation server and logic
- Free & Pro: Data diff - fix lost focus of grid on selection and jump previous/next from toolbar
- Free & Pro: Table definitions - fix multicolumn key recognition for data diff
- Free & Pro: Data diff - mark key columns in headers
- Free & Pro: Fix unexpected error dialog if file there are no files to load (invalid format, n/a for Free, etc)
- Pro: Fixed broken Query result diff
- Pro: Data diff - 'No comparison key(s)' and 'Sorting on non-key column(s)' result warnings
- Pro: Data diff - fix invalid delete action availability for data diff without key
1.3.1, 2020-11-01
- Free & Pro: Show all/new/changed/new+changed actions - remove 'records' from tooltip text since starting from 1.3.0 it is applicable for text diff as well
- Pro: Project tab - 'from path in clipboard' action
- Pro: Project tab - Excel export
- Pro: Data diff - allow to merge/delete wtihout PK for custom data diff and custom column mapping
- Pro: Data diff - 'Compare definition' action, 'Column mapping' action changed from text to icon
- Pro: Text diff - 'Compare data' actions
1.3.0, 2020-10-23
- Free & Pro: Data diff - completely new grid controls to fix some coloring glitches on large grids
- Free & Pro: Data diff - reduce memory leaks
- Free & Pro: Data diff - showing blank triangles on sortable columns
- Free & Pro: Showing hourglass on waiting for diff update after DB load
- Free & Pro: Fix occasional application deaths on data diff (AccessViolationException)
- Pro: Text diff - ability to show new/changed lines only
- Pro: Data Diff, Object List - consider new items block from one side followed by new block on other side as a jump target for new/previous change actions
- Free: don't show 'Unexpected error' on data diff limitations (just regular message dialog)
1.2.1, 2020-06-02
- Free & Pro: Data merge/delete with 'Process all pages' option - don't try generate scripts for missing records, fix 'records to be processed' counter value for such cases; fix string&binary formatting
- Free & Pro: Fix missing suggestion to merge all pages if current page (merge source or deletion target) has any deleted records for the right tab
- Free & Pro: Improve data merge scripts generation performance
- Free & Pro: Updated app icon
- Pro: Query result diff - fix STA error for basic and custom diff mapping
- Pro: Settings - fixed Restore Defaults action for pragmas
- Pro: Data diff, Query result diff - reset selected count on page/resultset change
1.2.0, 2020-04-30
- Free & Pro: System requirements: application now requires .NET framework 4.7.2 or higher, discontinued support of Windows XP, Vista and 8 (supported Windows 7, 8.1 and 10)
- Free & Pro: Data diff - using local cache for string and binary data and for data merge scripts, this should fix most of out-of-memory errors which could appear before; on UI strings are truncated to 100 characters
- Free & Pro: New 'Execute data script' dialog with options to run as transaction and stop of first error, new option to save script and results to file (save whole script to file and clipboard are available for Pro only)
- Free & Pro: Data diff - fixed potential record count overflow errors for large number of records
- Free & Pro: Don't show 'Unknown error' dialog for out-of-memory errors and valid application errors like missing internet connection on trial activation
- Free & Pro: 'Unknown error' dialog - minor text adjustments
- Free & Pro: License text and installation folder updated with new ThirdPartyNotices.txt file
- Pro: Load and compare PRAGMAs
- Pro: Support for SQLCipher-encripted files
- Pro: Open protected files dialog - ability to specify PRAGMAs to run on connection open, required to support different versions of SQLCipher-encripted files
- Pro: New 'Merge all pages' dialog and data diff Settings options
- Pro: Settings - new data diff 'Local cache folder' setting
1.1.2, 2020-01-22
- Free & Pro: Data diff - show NULL values explicitely
- Free & Pro: Data diff - grid interaction performance improvements
1.1.1, 2020-01-20
- Pro: fix page total zeros on non-first pages
1.1.0, 2020-01-16
- Free & Pro: Data diff - run in background
- Free & Pro: Improved unexpected errors handling and logging
1.0.3, 2020-01-11
- Free & Pro: Project tab - added 'Recent projects' bottom panel
1.0.2, 2019-11-04
- Free & Pro: Data diff - fix string compare options (case insensitive, ignore whitespaces)
- Free & Pro: Execute script dialog - update underlying tab right after Run (and before Close)
- Pro: Object list - always show Selected count
1.0.1, 2019-10-18
- Free & Pro: Fix app crash on unexpected error
- Free & Pro: Object list - Alt+C shortcut for 'Compare selected' option
- Free & Pro: Exclude possible stack trace duplicates in application error log
- Free: deny *.sqlts files support
1.0.0, 2019-09-20
- Free & Pro: Online help on F1 keyboard shortcut
- Free & Pro: Tab icons
- Free & Pro: Project panel object type icons
- Free & Pro: Some uncommon tab-specific actions moved to the separate toolbar
- Free & Pro: Project reload warning and options
- Free & Pro: Dynamic tab header width (max value configurable in Settings)
- Free & Pro: Zoom button splinted into separate zoom in / zoom out buttons
- Free & Pro: Show loaded project names in application title
- Free & Pro: Rename field -> column in some UI elements
- Free & Pro: Find tab - acceleration keys, Alt+S (search for), Alt+L (left project) Alt+R (right project), Alt+W (match whole word), Alt+C (match case)
- Free & Pro: deny visual (not actual) object/row deletion from some data grids (data diff, query result diff)
- Free & Pro: fix rare 'bad parameter or other API misuse' error on database open of two files at the same time
- Free & Pro: change file open icons
- Pro: Object list text diff preview
- Pro: Diff overview in scrollbar (for object list, data diff, text diff, batch data diff, query result diff)
- Pro: Settings - new 'Appearance' tab with 'Don't resize toolbar on application zoom' option
- Pro: Query key columns dialog - don't show if there are no columns to choose
- Pro: Batch data diff - column sorting
- Pro: Settings - new 'Appearance' tab with 'Don't resize toolbar on application zoom' option
- Pro: Command line - /pwd keys support (with Left/Right suffix each)
- Pro: Query result diff - fix error on row selection by space
- Pro: Excel - fix always-plus 'exists in' value for object list and table structure diff
0.1.0, 2019-01-31
- Free & Pro: Initial public version