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

What's New

1.15.1, 2024-07-12

- Free & Pro: Activation dialog - fix typo in the 'Information about current license'
- Free & Pro: What's new tab - fix typo in the 'Information about current license'
- Free & Pro: Fix cases of splash screen jump for non-100% system display scale
- Pro: Batch data diff - click on Custom Query new/changed - open Query result diff with appropriate filter

1.15.0, 2024-07-08

- Pro: Change format of diff profile files, suggest convertion to the new format on load
- Pro: Diff profile editor - new 'Data slices' section
- Pro: Diff profile editor - 'Show in Batch data diff' option for table mappings and queries
- Pro: Diff profile editor - 'Created' column and sorting on all columns in all grids
- Pro: Batch data diff - options to show 'Custom mappings' and 'Custom queries' from diff profile
- Pro: Batch data diff - 'Create data slice' command
- Pro: Batch data diff - Data slice mode to show data slice, comparing to the regular mode it has data slice name in the tab header, different tab icon and removed 'Create data slice' command
- Pro: Custom data diff - allow to save to diff profile mappings for different tables, title changed to 'Save to diff profile and use by default' for same tables and 'Save to diff profile' in other cases
- Pro: Query result diff - ask for diff profile title on save
- Pro: Batch data diff - minor performance improvement for large amount of tables

1.14.0, 2024-05-23

- Free & Pro: Home tab - allow to drag & drop database and *.sqlts files (dragging to any other tab will open Home tab)
- Free & Pro: Update System.Data.SQLite library to the latest available 1.0.118 based on SQLite 3.42.0 (used for unprotected files)
- Free & Pro: Find tab - fix default focus on search textbox
- Free & Pro: Check for local cache folder existence on startup
- Pro: Update SQLitePCLRaw.bundle_e_sqlcipher library to the latest available 2.1.8 based on SQLite 3.39.2 (used for protected files)
- Pro: Data diff - merge rows of table without DL and having other foreign-key-dependent tables - fix invalid unconditional Id-Remap logic, replaced with unconditional regular data merge (Id-Remap can't be done for tables without DL)
- Pro: Data merge warning dialog - warn about auto-increment merge and non-applicable Id-Remap caused by missing dependency level
- Pro: Data merge - fix ignored saved 'Merge all page' setting in case of Id-Remap confirmation shown (without 'Merge all pages' confirmation)
- Pro: Data diff - Export all pages confirmation dialog
- Pro: Settings - 'Export all pages' data diff settings
- Pro: Open protected files dialog - 'Save passwords' option
- Pro: Open protected files dialog - 'Encrypt passwords' option for *.sqlts files
- Pro: Open protected files dialog - misc fixes related to controls and actions state
- Pro: Open protected files dialog - allow to drag & drop files to file name text boxes
- Pro: Open protected files dialog - minor lables and layout adjustments
- Pro: Home tab - indicate that recent database requires password entry (was opened by password without saved password)
- Pro: Query result diff tab - fix default focus on query text
- Pro: Excel exports without opening file - remove hour glass before report completion notification
- Pro: Data merge confirmation, copy all results - fix in 1000000 limit message 'Script' -> 'Combined result'
- Free: Text diff - fix missing changes in background highlight on switching text diff options

1.12.4, 2024-04-06

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

1.12.3, 2024-03-20

- 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

- 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

1.12.1, 2024-03-01

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

1.12.0, 2024-02-13

- 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

1.11.2, 2024-02-01

- 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

1.11.1, 2024-01-25

- 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

1.11.0, 2024-01-19

- 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

1.10.3, 2023-12-08

- 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

1.10.2, 2023-08-31

- 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

1.10.1, 2023-08-04

- Free & Pro: Table definition merge confirmation dialog - minor label adjustments regarding Data diff
- Pro: Settings - allow to configure SQLite file extensions for 'open database' action
- Pro: Batch data diff - populate startup data in the background and fix occasional DispatcherUnhandledException unexpected error for large lists
- Pro: Data merge - fix ignored disabled AUTOINCREMENT for Copy ALL and Save ALL actions

1.10.0, 2023-06-28

- Free & Pro: Home tab, database open - 'Close both' progress action (useful if both progresses have errors)
- Free & Pro: Data diff tab - show italic NULL text for NULLs in columns with 'visual match' mapping (which have a gray background color, was just nothing before)
- Pro: Object list - show selected count only if something selected
- Pro: Home tab - added DIFF ONLY tooltip text for Pragmas
- Free: Allow to drop and merge new only table definitions, mark them as MERGE NEW ONLY on the Home tab and update tooltip text for that mark
- Free: Data diff - show total counts in the top panel
- Free: Object list - show counts in the top panel
- Free: Text diff - show counts in the top panel
- Free: Data merge/delete 'all page records selected' confirmation warning - add clarification that other pages are not going to be processed

1.9.7, 2023-05-05

- Free & Pro: Handle settings reading error on app start
- Free & Pro: Unknown error dialog - minor label adjustments
- Free & Pro: Updated code sign certificate (may cause smart screen warnings)
- Pro: Batch data diff, merge new and changed - add option to delete target records missing in source
- Pro: Query result diff - add result error tooltip showing the whole error text (useful if error is truncated)
- Pro: Custom data diff - fix unknown error on specifying the same column twice (as left without pair vs right without pair)

1.9.6, 2023-02-27

- Free & Pro: Database open - don't fail the whole database if failed to get table_info for some table or view (for example if view is based on non-existing table)
- Free & Pro: Data diff - fix 'Failed to define merge script structure' delete script generation error in case of changed key name(s) (custom mapping or case-sensitive only changes)
- Free & Pro: Home tab - recent databases, opening DBs from toolbar one by one - fix invalid left side progress for the second DB
- Free & Pro: Home tab - new 'Delete this pair from recent database list' button
- Free & Pro: Apply zoom to almost all dialogs (except unknown error and initial activation dialog)
- Free & Pro: Parallel database open - improved progress completion responsiveness
- Free & Pro: Open database(s) icon updated to be the same as on the Home tab (without 'plus')
- Free & Pro: Collapsed database file name path - show full path in tooltip (where missing, before it was done only for Recent file list)
- Free & Pro: Activation dialog - minor label and layout adjustments, change support email to use the new ksdbmerge.tools domain
- Free & Pro: Activation dialog - more responsive processing of trial retreival, disable OK during execution to fix 'DialogResult can be set only after..' occasional error
- Free & Pro: Check for updates - change requested url to use the new ksdbmerge.tools domain
- Free & Pro: Data merge warning dialog - minor layout adjustments
- Free & Pro: EULA minor adjustments regarding location
- Pro: Batch data diff - don't generate scripts on delete cancellation
- Pro: Batch data diff - minor label adjustments
- Pro: Data diff - fix 'key not found' error on using non-applicable diff profile mapping, ignore such mappings
- Pro: Query result diff - hide per page counts (there is no paging), show selected counts only if any record selected
- Pro: Query result diff - show resultset number only if there is more than one resultset
- Pro: Data diff - show selected counts only if any record selected
- Pro: What's new - 'license key is not valid for this update' notice

1.9.5, 2023-01-26

- Free & Pro: Run data script dialog - new option 'Import existing AUTOINCREMENT values on INSERT'
- Free & Pro: Data diff tab - fix null reference error on open for text column having text saved as blob by Microsoft.Data.Sqlite
- Free & Pro: Data diff tab - fix non-closeable progress on merge/delete script generation failure
- Free & Pro: Data diff tab - fix occasional 'index out of range' error on merge/delete all pages for table with changed columns
- Free & Pro: Data diff tab - save error log for unexpected error on tab open
- Pro: Batch data diff - show 'No data records matching your criteria were found' on merge/delete if there is no data to process
- Pro: Batch data diff - better merge/delete progress indication
- Pro: Batch data diff - fix slow and unresponsive merge/delete if no totals were pre-calculated
- Pro: Batch data diff - provide inner exception in case of script generation failure

1.9.4, 2023-01-21

- Pro: Batch data diff - merge/delete actions made active allowing to process multiple selected tables
- Pro: New 'Batch data merge warning' dialog
- Pro: Execute data script - show table name with 'and N more' if processing more than 1 table from the Batch data diff
- Pro: Object list - fix new virtual table definition merge
- Pro: Apply connection open pragmas without protection (using 'Open protected files' dialog and 'None' protection type), making it possible to process data with foreign keys validation

1.9.3, 2023-01-15

- Free & Pro: Msi - allow per-user installation, without UAC confirmation and Administrator privileges (upgrade from per-machine to per-user still requires Administrator privileges to uninstall previous per-machine version)
- Free & Pro: Msi - change images to application icon
- Free & Pro: Msi - option to launch after installation completion
- Free & Pro: Object list - don't re-create unchanged objects on merge
- Free & Pro: Object list - allow merge only if there are any new or changed item (deny if all items are unchanged)

1.9.2, 2022-12-30

- Free & Pro: Merge objects dialog - increase Execution result area, allow window resize/minimize/maximize
- Free & Pro: Merge data dialog - allow window resize/minimize/maximize
- Pro: Object list - ability to alter multiple tables
- Pro: Object list - DL column for tables with configurable visibility (foreign key dependency level)
- Pro: Batch data diff - DL columns (foreign key dependency level)
- Pro: Table structure diff - fix some cases of unnecessary table re-creation when simple ALTER TABLE is enough
- Pro: Merge objects dialog - alter table(s) warning
- Pro: Merge objects dialog - new 'Save to file' action for script and execution result
- Pro: Custom data diff - allow window resize/minimize/maximize

1.9.1, 2022-12-23

- Free & Pro: Data diff - case-insensitive primary key column match
- Free & Pro: Object list - handle connectivity failure on Refresh
- Free & Pro: Database open progress on table definition merge or table list refresh - clarify multiple "Calculating changes" with object type name
- Free & Pro: Data diff - fix sorting in the right panel on columns having case-sensitive changes
- Free & Pro: Object list - fix swapped progress panels on Refresh
- Pro: Table structure diff - fix merge of new column for table having moved columns (they were producing column duplicates in the temporary table)
- Pro: Handle copy to clipboard error (clipboard can be busy with some other app, https://stackoverflow.com/a/68857/282694)
- Pro: Batch data diff - Select row with single click (like in object list and data diff, instead of double)
- Pro: Batch data diff - Fix calculation of Total+New for the case of Common key = No (was SQL error before)
- Pro: Table structure diff - Case-insensitive match by name

1.9.0, 2022-12-02

- Free & Pro: Update hyperlinks, grids, text, selection look & feel
- Free & Pro: Recognize virtual tables and potential shadow tables, mark them respectively in the Object list
- Free & Pro: Open virtual tables as text (if at least one of sides is a virtual table)
- Free & Pro: Data diff - show warning for potential shadow tables
- Free & Pro: Data diff - fix rare occasional ArgumentOutOfRangeException on open (was 'unknown error' before)
- Free & Pro: Data diff - fix merge script generation for changed case of column names and custom mapping
- Free & Pro: Object list - object name hyperlink tooltips
- Free & Pro: Toolbar online help button
- Free & Pro: Update app icon
- Free & Pro: Data diff - add 'Page'/'Paging' label
- Pro: Scroll background changes indication - more pale colors, fixed Changed indication in the object list
- Pro: Table structure diff tab - show warning for potential shadow tables
- Pro: Text diff - hide 'Open table definition' button for virtual tables
- Pro: Query key fields and Custom data diff dialogs - case-insensitive column match
- Free: Data diff paging and page merge confirmation
- Free: Data diff - remove limitation on number of columns and key definition
- Free: Home tab - allow show new/all/changed

1.8.5, 2022-09-14

- Free & Pro: Recognize TRUE/FALSE column default values (in table script and Table structure diff tab)
- Free & Pro: Data diff - fix cases of REAL false-positive changes caused by internal approximacy

1.8.4, 2022-08-25

- Free & Pro: Unknown error dialog - add 'recommended' for option 'Send error report and close'
- Free & Pro: Improve action logs for 'Unknown error' reports (merge/delete actions, table structure diff item selection)
- Pro: Table structure diff - fix nullref unknown error on constraint drop for a table with removed column

1.8.3, 2022-05-17

- 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: New tab - Diff profile editor, opened by click on loaded diff profile status on the Home tab
- Pro: Home tab - fix possible multiple active profiles on adding new profile
- Pro: Query result diff - 'Save to diff profile' option
- Pro: Query key columns dialog - add 'Save to diff profile' option
- Pro: Batch data diff - calculate new/changed counts for views with defined key
- Pro: Batch data diff - 'Common primary key' renamed to 'Common key' and now includes keys defined in the diff profile
- Pro: Custom mapping dialog opened from Query result diff tab - remove 'Save to diff profile' option

1.8.2, 2022-05-06

- Free & Pro: Fix table definition parsing for tables having constraint with square-bracked name not delimited with space (..,constraint[c])
- Free & Pro: Data diff, Batch data diff - fix nullref on GetCompareKeyInfo caused by invalid table definitions

1.8.1, 2022-05-05

- Free & Pro: Database open progress - show critical table definition parsing errors
- Pro: Batch data diff - attempt to fix nullref on Enumerable.Union caused by invalid table definitions

1.8.0, 2022-04-29

- Pro: Initial 'Diff profiles' implementation - setup in Custom data diff and apply in Data diff and Batch data diff
- Pro: Home tab - add 'Diff profiles' section
- Pro: Custom data diff - add 'Save to diff profile' option
- Pro: Custom data diff - minor label adjustments

1.7.4, 2022-04-16

- Free & Pro: Text diff - highlight in yellow lines with ignored case-insensitive or whitespace changes
- 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'
- Pro: Query result diff - in case of error show it without db name
- Pro: Object list, Query result dif - bottom grid - reduce a bit header height to make inner horizontal border more visible
- 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
- Free: Object list - 'Compare two selected items' hidden for tables

1.7.3, 2022-03-29

- Free & Pro: add "Compatibility Mode" application shortcut to start with COR_ENABLE_PROFILING=0 environment variable (to avoid conflicts with profilers)
- Free & Pro: fix action log memory consumption
- 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 run, forse query split and run both only against opened DB

1.7.2, 2022-03-04

- 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: Table structure diff - fix 'Exists In' population in Excel
- Pro: Custom data diff - show mapping type and sorting as radio-button to change them in single click
- Custom data diff - change 'project' -> 'database'

1.7.1, 2022-02-17

- Free & Pro: Home tab - change 'Recent projects' -> 'Recent databases'
- Free & Pro: Project/Database reload confirm dialog - change 'project' -> 'database'
- Pro: Settings dialog - change 'project' -> 'database'
- Free: Object list - deny table delete

1.7.0, 2022-02-16

- Free & Pro: Home/Project tab redesign
- Free & Pro: Home/Project tab - Close other tabs, updated Close icon for other tabs
- Free & Pro: Home/Project tab - Open Object list on object type click, added tooltips for other grid hyperlinks
- Free & Pro: File open progress - add one more 'Calculating changes..' step
- Free & Pro: File open progress - show file open errors in progress panel (instead of dialog)
- Free & Pro: Text diff - fix occasionally missing underscore on some display settings
- Free & Pro: Header panel redesign for Find tab, Batch data diff and Query result diff tabs
- Pro: Home/Project tab - new 'Show in folder' action
- Pro: Object list - add 'Open table definition as text' action for table definitions
- 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
- Free: Limit number of opened Find tabs

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