What's new in KS DB Merge Tools for SQLite 1.12.4
Apr 6, 2024
- Free & Pro: Home - fix bug 'Open single database, Refresh, and other side loaded with the same DB instead of refresh'
- Free & Pro: SQL syntax highlight - recognize multiline strings
- Free & Pro: What's new - enable word wrap for list of changes to avoid horizontal scroll for long items
- Free & Pro: Text diff - change line numbers to dark-gray to avoid visual confusion with actual text
- Free & Pro: Fix focus on selected tab, switching between data diff tabs and clicking Refresh could produce selection of some other previously focused tab
- Free & Pro: Data diff - add 'Click to sort by this column' column tooltip where applicable
- Pro: Data diff - export to Excel: fix identification of 'string' data type as a string/text data type, number-only values could be formatted as numbers during export
- Pro: Table structure diff - show 'Compare data' and 'Open in Query result diff' buttons for tables missing on other side (or other side db is not loaded at all)
- Pro: Query result diff - fix cases of missing first row selection on Run (and therefore fix missing bottom row grid)
- Pro: Query result diff - clear previous result on subsequent Run
- Pro: Query result diff - handle properly cases when only one side result is available (error on other side, different resultset count, other side returned no table result)
- Pro: Query result diff - error text word wrap, ability to copy, and some other layout updates
- Pro: Text diff - new 'Show tabs and spaces' toggle
- Pro: Text diff - new bottom line implementation, with selectable text and fixed tabulation width
- Pro: Data diff - allow to compare string values in the separate text diff tab (the up-right arrow near column name in the bottom grid, useful for multiline values)
New in KS DB Merge Tools for SQLite 1.12.3 (Mar 20, 2024)
- Free & Pro: EULA updated (divided into sections, more information and clarifications)
- Pro: Query result diff - fix unexpected error on compare by row number then click result column name to sort
- Pro: Custom data diff - fix validation of sorting on more than one non-key column
- 1.12.2, 2024-03-05
New in KS DB Merge Tools for SQLite 1.12.2 (Mar 5, 2024)
- Free & Pro: Fix blinking splash screen after main window open
- Pro: Table definition merge - fix failures caused by spaces in table/column names (missing quotes)
- Pro: Text diff - change Expand above/below links to folding sections (and fix some syntax highlight issues if it shows new/changed lines)
- Pro: Text diff - show 'Additional lines' configuration directly in tab and remove it from Settings
- Pro: Text diff - if show only new/changed lines, do not hide block containing only one line
New in KS DB Merge Tools for SQLite 1.12.1 (Mar 1, 2024)
- Free & Pro: SQL syntax highlight - highlight identifiers and numbers, reduced list of keywords to the most generally used
- Free & Pro: Splash screen
- Free & Pro: Updated application binary protection
- Free & Pro: Data diff - use the same fonts in the merge/delete progress as in other places
- Free & Pro: Fix 'Full screen' toggle state if changed by F11
- Free & Pro: Fix 'It is an expired trial key' key entry error presentation
- Pro: Custom data diff - fix broken paging on setting up sort order for more than one key
- Pro: Custom data diff - deny sorting on more than one non-key column (not supported)
- Pro: Custom data diff - minor layout adjustments
- Pro: Text diff - fix scroll to the next/previous change
- Pro: Text diff - fix navigation to the found line on click from the Find tab
- Pro: Fix cases of broken Ctrl+C in the new text editor (Query result diff, etc.)
New in KS DB Merge Tools for SQLite 1.12.0 (Feb 13, 2024)
- Free & Pro: SQL Syntax highlight in the Text diff, Object list text preview, Merge dialog and Query result diff
- Free & Pro: Application Full screen mode, with F11 shortcut
- Free & Pro: Exclude system tables like sqlite_sequence, configurable for Pro
- Pro: Id-Remap Merge dialog - fix occasionaly broken table order by name for same DL
New in KS DB Merge Tools for SQLite 1.11.2 (Feb 1, 2024)
- Free & Pro: Data diff - fix nullref error on opening for a table with parsing errors during database open, use table_info metadata for such table (anonymous unexpected error report)
- Free & Pro: Fix parsing of non-quoted identifiers with non-latin characters. Previously table parsing could fail and app was using reduced table_info metadata
- Free & Pro: Home tab, database open - save table definition parsing errors to the temporary log file, path printed to the progress errors
- Free & Pro: Home tab - 'Copy all' database open progress action, appearing in case of errors
- Free & Pro: Reduce cases of duplicated ';' in generated scripts
New in KS DB Merge Tools for SQLite 1.11.1 (Jan 25, 2024)
- Pro: Id-Remap Merge - fix cases of missing child rows when child table has multiple nullable foreign keys and some of them have NULL values
- Pro: Id-Remap Merge from Data Diff - refresh tables list on merge completion to update 'Other parents' mappings for subsequent Id-Remap Merge actions
- Pro: Id-Remap Merge - do not use mapping tables subquery for NULL source values
New in KS DB Merge Tools for SQLite 1.11.0 (Jan 19, 2024)
- Free & Pro: Object list - show object action buttons for new objects or if other side db is not opened (as result, allow to view data)
- Free & Pro: Home tab - fix truncation of long file paths in the recent database list
- Free & Pro: Data merge dialog - minor label fixes
- Pro: Id-Remap Merge new feature allowing to merge properly foreign key values referencing to autoincrement/identity numeric primary keys, integrated with Data Diff and Batch Data Diff merge actions
- Pro: Batch data merge dialog - show Id-Remap Merge suggestion and applicability warnings in appropriate cases
- Pro: Data merge dialog - show Id-Remap Merge suggestion in appropriate cases
- Pro: Batch data merge dialog - minor label fixes
- Pro: Batch data merge dialog - Alt hotkeys
- Pro: Query result diff - 'Split..' and 'Run both..' options adjustments for the new case of opening from tables Object List when other side db is not opened
New in KS DB Merge Tools for SQLite 1.10.3 (Dec 8, 2023)
- Pro: Query key columns dialog - restore broken 'Save to diff profile' option
- Pro: Batch data merge dialog - restore lost note regarding script generation time and space
- Pro: Batch data diff - fix invalid 'Change columns' = No for the case of new column(s) in the left DB without other
New in KS DB Merge Tools for SQLite 1.10.2 (Oct 9, 2023)
- Free & Pro: Fix occasional 'Cannot set Owner property to a Window that has not been shown previously' unexpected error for basic dialogs
- Free & Pro: Improved logic of changes invalidation after objects merge and refresh
- Free & Pro: Fix app crash on unknown error during dialog open
- Pro: Support for All-in-one license
- Pro: Home tab - Add 'Show in folder' for recent database items
- Pro: Fix 'Cannot call StartAt' unknown error on Batch data diff -> click on view name -> compare data
- Pro: Encrypt command line passwords on opening database in the new app instance