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

What's New

1.6.0, 2022-06-30
- Free & Pro: Verified MariaDB 10.8 compatibility
- Free & Pro: Fix table definition reading for case when it has two constraints with the same name (unique and FK)
- Free & Pro: Show database open progress errors on the fly instead of accumulation
- Free & Pro: License Info dialog - after trial/full key submission keep app in the pure Free mode until restart (previously some Pro features could become partially available and cause some errors)
- Pro: Home tab - add 'Diff profiles' section
- Pro: New tab - Diff profile editor, opened by click on loaded diff profile status on the Home tab
- Pro: Custom data diff - add 'Save to diff profile' option
- Pro: Query key columns dialog - add 'Save to diff profile' option
- Pro: Query result diff - 'Save to diff profile' option
- Pro: Batch data diff - calculate new/changed counts for views with keys defined in the diff profile
- Pro: Batch data diff - 'Common primary key' renamed to 'Common key' and now includes keys defined in the diff profile
- Pro: Batch data diff - optimize 'new only' calculation
- Pro: Custom data diff - minor label adjustments
1.5.4, 2022-04-15
- Free & Pro: Find tab - Find button moved to the left and F5 shortcut added. Regex search added for Pro.
- Free & Pro: Unknown error dialog - 'Close' renamed to 'Close w/o report', added 'Close app'
- Free & Pro: Object list - remove usless Created and Modified columns for Views
- Pro: Query result diff - in case of error show it without db name
- Pro: Query result diff - reset selection count on resultset change
- Pro: Object list, Query result dif - bottom grid - reduce a bit header height to make inner horizontal border more visible
- Pro: Object list - remove useless column checkboxes for Foreign keys
- Pro: Table structure diff - fix some cases of missing bottom grid update on rigth column click
- Pro: Table structure diff - cases of grayed out row selection are replaced with merge/delete deny reason tooltip
- Pro: Data diff - reset selected count on page change
- Free: Object list - 'Compare two selected items' hidden for tables
1.5.3, 2022-04-06
- Free & Pro: Data diff - fix binary fields processing (broken in 1.5.1)
- Pro: Settings, Text Diff - fix lost custom normalization options on Settings dialog open
1.5.2, 2022-04-05
- Free & Pro: Text diff - highlight in yellow lines with ignored changes (case-insensitive, ignore whitespace, custom text normalization)
- Free & Pro: Open database dialog - option 'Encrypt passwords' for *.mydbs files
- Pro: Settings, Text Diff - add custom text normalization rules
- Pro: Settings, Text Diff - add 'Ignore empty lines' option
1.5.1, 2022-03-31
- Free & Pro: add "Compatibility Mode" application shortcut to start with COR_ENABLE_PROFILING=0 environment variable (to avoid conflicts with profilers)
- Free & Pro: Home tab - fix broken open recent db without saved password (show Open database dialog asking for password)
- Free & Pro: improve settings stability by using read/write retry attempts
- Pro: Query result diff - show query execution errros as counts overlay instead of message box
- Pro: Query result diff - fix query cancellation
- Pro: Query result diff, when single db opened - fix nullref on single query
- 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: Data diff - in case of limitations show regular dialog instead of unknown error
- Free: Object list - deny table delete
1.5.0, 2022-03-05
- Free & Pro: Home/Project tab redesign
- Free & Pro: Home/Project tab - Close other tabs, updated Close icon for other tabs
- Free & Pro: Header panel redesign for Find tab, Batch data diff and Query result diff tabs
- Free & Pro: File open progress - add one more 'Calculating changes..' step
- Free & Pro: File open progress - show database open errors in progress panel (instead of dialog)
- Free & Pro: Object lists - highlight Created/Modified dates of changed objects as yellow (color of ignored change) instead of red to indicate that date is not the reason of considering object as changed
- Pro: Generate xlsx reports without use of Excel, improve report generation performance
- Pro: Settings - Appearance tab renamed to Misc, added new options for ambiguous object names and reports
- Pro: Custom data diff - show mapping type and sorting as radio-button to change them in single click
- Pro: Custom data diff - change 'project' -> 'database
- Pro: Object list - add 'Open in Query result diff' action for table definitions and views
- Pro: Table structure diff - add 'Open in Query result diff' action
- Pro: Table structure diff - Excel export
- Pro: Batch data diff - object name click - open Table structure diff for tables, indented Text diff for queries
- Free: Limit number of opened Find tabs
1.4.4, 2022-01-28
- Free & Pro: Fix CURRENT_TIMESTAMP default SQL generation for MySQL 5.7 and below
- Free & Pro: Text diff - fix occasionally missing underscore on some display settings
- Pro: Object list - add 'Open table definition as text' action for table definitions
1.4.3, 2021-12-21
- Free & Pro: Activation dialog - allow to configure 'check for updates', updated some information
- Free & Pro: Project tab - change 'reload' label to 'refresh' and run action without closing other tabs
- Free & Pro: Text diff - 'Ignore empty line' option
- Pro: 'Copy to selection to clipboard' action, applicable for Project tab, Object list, Data diff, Text diff and Query result diff
- Pro: Table structure diff - fix nullref error on 'Compare data (new and changed)'
- Pro: Query result diff - fix index out of range error
- Pro: Object list text diff preview - fix disappearing scrollbar issue
- Free: Object list - fix 'Sequence contains no matching element' error on Table definitions refresh
1.4.2, 2021-11-11
- Free & Pro: Fix showing 'new version released' for the same version
- Free & Pro: MariaDB - update script generation and merge logic for column DEFAULT values
- Free & Pro: MariaDB - update script generation for foreign keys - exclude default RESTRICT clause
- Free: Make Refresh action available
1.4.1, 2021-11-09
- Free & Pro: Fix broken comparison of binary/blob values
- Free & Pro: Data diff - truncate varchar, tinytext, mediumtext and longtext data on UI to 100 chars (the same way as for char and text)
- Add Refresh action applicable for Data diff and Object list tabs
- Table structure diff tab - fix missing size for bit data type
1.4.0, 2021-11-01
- Free & Pro: Tab toolbar actions moved inside tab, into the panel splitter
- Free & Pro: Check for updates implemented for future updates. Can be disabled using 'Information about current license' dialog (blue 'i' toolbar button)
- Free & Pro: Table definitions - use script generated by application instead of SHOW CREATE TABLE result
- Free & Pro: Enable legacyUnhandledExceptionPolicy to avoid crash after background thread error
- Free & Pro: More usage of system control background color
- Free & Pro: Minor text adjustments in the activation and settings dialogs
- Pro: Table structure diff tab - restored and redesigned, allowing to merge/delete columns, constraints and indexes
- Pro: Project tab - removed "Indexes (non-primary)". Indexes, including PRIMARY KEY are managed now using Table structure diff tab
- Pro: Project tab - removed "MERGE NEW ONLY" mark for Table definitions since now they can be edited using Table structure diff tab
- Pro: Object list - fix Replace action tooltips for foreign keys
1.3.1, 2021-06-04
- Free & Pro: Toolbar - showing tooltips on disabled buttons, with disable reason
- Free & Pro: Open databases dialog - 'Save passwords' option added
- Free & Pro: Increase row heights of some grids (to be the same as for data diff)
- Free & Pro: Open databases dialog - 'Test connectivity' actions
- Free & Pro: Object list - performance improvements for large amount of objects
- Pro: Open databases dialog - SSH connectivity support
- Pro: Project tab - ability to show new/changed lines only
- Pro: Project tab - update presentation of DB port number
1.3.0, 2021-03-10
- Free & Pro: For now Table structure diff tab replaced with Text diff tab because 1) it is not enough to cover all table options, and 2) to provide consistency between object list bottom text preview, table definition and table merge text. Table script is taken as SHOW CREATE TABLE result without table options (particularly to avoid AUTO_INCREMENT changes which are caused by data)
- Free & Pro: Project reload dialog simplified
- Free & Pro: Fix app start failure caused by FIPS
- Free & Pro: Updated app icon
- Pro: Custom data diff - fix failure caused by mapping duplicates
1.2.2, 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
- Free: Find tab - fixed nullref error and reduced results
1.2.1, 2020-12-10
- Free & Pro: Data diff - fixed column headers truncated text for 100% windows scaling
- Pro: Query result diff - fix missing data changes highlight
1.2.0, 2020-12-07
- Free & Pro: Updated MySqlConnector to 1.2.0, tested MariaDB compatibility
- Free & Pro: Data diff - show NULL values explicitely
- 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: New instanceId algorithm (to reduce collisions), updated trial activation server and logic
- Free & Pro: Data diff - mark key columns in headers
- Free & Pro: License text and installation folder updated with new ThirdPartyNotices.txt file
- Free & Pro: Handle AccessViolationException
- Pro: Ability to delete and merge table definitions (MERGE NEW ONLY)
- Pro: Foreign keys support
- Pro: Indexes support
- Pro: Text diff - ability to show new/changed lines only
- Pro: Data diff - 'No comparison key(s)' and 'Sorting on non-key column(s)' result warnings
- Pro: Data diff - 'Compare definition' action, 'Column mapping' action changed from text to icon
- Pro: Text diff - 'Compare data' actions
- Pro: Project tab - export to Excel
1.1.3, 2020-01-20
- Free & Pro: Improved unexpected errors handling and logging
- Pro: Data diff - fixed some failures on jump previous/next change
1.1.2, 2020-01-13
- Free & Pro: Project tab - added 'Recent projects' bottom panel
1.1.1, 2019-08-04
- Free & Pro: Online help on F1 keyboard shortcut
- Pro: Query key columns dialog - don't show if there are no columns to choose
1.1.0, 2019-07-25
- Free & Pro: Tab icons
- Free & Pro: Project panel object type icons
- Free & Pro: Dynamic tab header width (max value configurable in Settings)
- Free & Pro: Some uncommon tab-specific actions moved to the separate toolbar
- Free & Pro: Deny visual (not actual) object/row deletion from some data grids (object list, data diff, query result diff, custom data diff, table structure diff)
- 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: Rename field -> column in UI (data diff tab, query result diff tab, query key columns dialog, custom data diff dialog)
- Free & Pro: Minor tooltip text update for select all/none actions
- Pro: Object list text diff preview
- Free: Allow sorting only on single-column primary key (was broken by background processing in 0.2.0)
1.0.1, 2019-05-31
- Free & Pro: Show loaded project names in application title
- Pro: Query result diff - fix STA error for basic and customized field mappings
- Pro: Query diff view - remove "no paging" label (AccdbMerge artefact)
1.0.0, 2019-05-23
- Pro: Diff overview in scrollbar (for object list, data diff, text diff, batch data diff, query result diff, table structure diff)
- Pro: Data diff - fix sorting (was broken by background processing)
- Pro: Batch data diff - fix some jump prev/next issues related to sorting
- Pro: Excel - fix always-plus 'exists in' value for object list and table structure diff
- Pro: Table structure diff - fix missing project names in excel export
- Pro: Query result diff - fix error on row selection by space
0.2.0, 2019-03-30
- Free & Pro: Data diff - run in background
- Free & Pro: Project reload warning and options
- Free & Pro: Zoom button splinted into separate zoom in / zoom out buttons
- Free & Pro: Database open dialog - remember last server names, port, 'use both' and 'display password' flags
- Free & Pro: Improved processing of unexpected failures
- Free & Pro: Improved database object reading error handling
- Free & Pro: open dialog - fixed lock on left port and username when you open only right DB
- Pro: Batch data diff - column sorting
- Pro: Settings - new 'Appearance' tab with 'Don't resize toolbar on application zoom' option
- Pro: Command line - /srv /port /db /user /psw keys support (with Left/Right suffix each)
0.1.5, 2019-02-15
- Free & Pro: Product renamed to 'KS DB Merge Tools for MySQL'
- Free & Pro: Append SQL data access for non-deterministic functions and stored procedures
- Free & Pro: Reading routine comments for functions and stored procedures
- Free & Pro: Open dialog usability fixes (tab order, saving Save/Load expanded state)
- Free & Pro: Start license dialog keyboard navigation improvements, updated Help text
- Free: Object list - fixed blocked by-mouse selection of the top item in list
0.1.4, 2018-11-23
- Free & Pro: Object list - fix broken drilldown to table structure only if one side loaded
- Pro: Data diff - fix paging
0.1.3, 2018-11-21
- Free & Pro: Fix duplicate key error on some projects load (use case sensitive db name filter on project load)
0.1.2, 2018-11-13
- Free & Pro: Initial public version