What's New
- Free & Pro: EULA updated (divided into sections, more information and clarifications)
- 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: 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: Query result diff - better error handling of database connection errors for some DBMS
- Pro: Text diff - new 'Show tabs and spaces' toggle
- Pro: Text diff - new bottom line implementation, with selectable text and fixed tabulation width
- 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: 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)
- Free & Pro: Splash screen
- Free & Pro: Verified compatibility with MariaDB 11.3
- Free & Pro: SQL syntax highlight - highlight identifiers and numbers, reduced list of keywords to the most generally used
- Free & Pro: Custom data diff - fix broken paging on setting up sort order for more than one key
- Free & Pro: Custom data diff - deny sorting on more than one non-key column (not supported)
- Free & Pro: Custom data diff - minor layout adjustments
- Free & Pro: Data diff - use the same fonts in the merge/delete progress as in other places
- Free & Pro: Fix 'It is an expired trial key' key entry error presentation
- Pro: Fix cases of broken Ctrl+C in the new text editor (Query result diff, etc.)
- 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 - if show only new/changed lines, do not hide block containing only one line
- Pro: Text diff - show 'Additional lines' configuration directly in tab and remove it from Settings
- Free & Pro: SQL Syntax highlight in the Text diff, Object list text preview, Merge dialog and Query result diff
- Free & Pro: SQLite - exclude system tables like sqlite_sequence, configurable for Pro
- Free & Pro: Ability to switch to the full screen, with F11 shortcut
- Free & Pro: Updated application binary protection
- Pro: Query result diff - deny run the different queries on same dbms
- Withdrawn release, same change list as for 1.5.1
- Free & Pro: Fix 'read sequences' database open error for MariaDB
- Free & Pro: Home tab, Object list - fix Refresh
- 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 - 'Copy all' database progress actions appearing in case of errors
- Free & Pro: Access - fix table column nullability
- Free & Pro: Reduce cases of duplicated ';' in generated scripts
- Free & Pro: Data merge dialog - minor label fixes
- Pro: Id-Remap Merge new feature allowing to merge properly foreign key values referencing to autoincrement/sequence 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: Batch data merge dialog - minor label fixes
- Pro: Batch data merge dialog - Alt hotkeys
- Pro: Data merge dialog - show Id-Remap Merge suggestion in appropriate cases
- Pro: Access - fix ForeignKey/Relation identification (was counted as new instead of same/changed)
- Pro: Query result diff - 'Split..' and 'Run both..' options adjustments for the new case of opening from Object List when other side db is not opened
- Free & Pro: Oracle - Fix ORA-01008 on paging for table with multi-column primary key
- Free & Pro: MySQL - Fix processing of Geometry data types for MySQL 8.1 and 8.2
- Free & Pro: MySQL and MariaDB - Verified compatibility with MySQL 8.1, 8.2 and MariaDB 11.2
- Free & Pro: SQL Server - Open db with server authentication and without saved password from recent list - fix invalid Windows Authentication and focus on password in the password prompt
- Free & Pro: Home tab - indicate that recent database requires password entry (was opened by password without saved password)
- Free & Pro: Opening db with save password if other side loaded and has no saved saved password - fix invalid save password for both (and the same for unsaved password)
- Free & Pro: Recent database open only if one side has no saved password - fix missing password for other side
- Pro: Fix 'Item with the same key has already been added' on some cases opening database having more than one index on the same table and columns
- Pro: Try to find other side matching index by table name, columns and index name first. If not found then match by table name and columns without index name (as previously).
- 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 changes
- Pro: Opening database in the new app instance: fix some cases of lost 'Save passwords' (both for other side database and the newly opened one)
- Free & Pro: Update Oracle metadata reading, fix view columns case-insensitive-duplicates check
- 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 object changes invalidation after refresh
- Free & Pro: Fix app crash on unknown error during dialog open
- Free & Pro: CREATE TABLE text - fix quoted identifiers for DBMS with schemas
- Pro: Initial support for foreign keys / relations
- Pro: Initial support for indexes
- Pro: Support for All-in-one license
- Pro: Fix 'Cannot call StartAt' unknown error on Batch data diff -> click on view name -> compare data
- Pro: Access - fix missing table DL
- Free & Pro: Oracle - verify compatibility with 12c
- Free & Pro: Oracle - fix null reference error on reading Personal Oracle Database and recognize Personal Oracle Database version
- Free & Pro: Oracle - more items in default exclude schemas list for new installations: APEX_040000, APEX_040200, ORDDATA, ORDSYS, RDSADMIN
- Free & Pro: Open database dialog - fix 'Test connection' ignoring database name for MySQL and PostgreSQL (was checking only connection to server)
- Free & Pro: Oracle - Fix column reading on 11g and verify compatibility with 11g
- Free & Pro: Oracle - Fix 'ORA-01882: timezone region not found' if client has timezone not configured for server
- Free & Pro: Oracle - Retry database connection open on timeout
- Free & Pro: Oracle database support
- Free & Pro: Fix some issues for MariaDB 11.0 and verify its compatibility
- Free & Pro: Fix bug that no-schemas side Home changed counts and Object list rows are multiplied by same-name-different-schema objects from has-schema side
- Free & Pro: Object list - change sorting to be based on both side items (previously left-side items were listed first)
- Free & Pro: SQLite - map String data type to String generic type (was Other before)
- Free & Pro: Access vs others - fix invalid NULL vs NULL calculation and presentation as 'changed'
- Free & Pro: Home tab, database open - 'Close both' progress action (useful if both progresses have errors)
- Free & Pro: Open database - clear server, user, password and database on selecting dbms not previously used
- 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)
- Free & Pro: Unknown error dialog - minor label adjustments
- Free & Pro: Open database dialog - fix 'Save passswords' typo
- Free & Pro: Update 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: Batch data diff - populate startup data in the background and fix occasional DispatcherUnhandledException unexpected error for large lists
- Pro: Batch data diff - for MS SQL merge target fix merge failure caused by multiple IDENTITY_INSERTs
- Pro: Database open - fix 'Open new app instance' behaviour (lost password)
- Pro: Data merge - fix ignored disabled identity/autoincrement for Copy ALL and Save ALL actions
- Pro: Query result diff - fix data type recognition for Access
- Pro: Settings - configure Oracle system schemas to exclude
- Pro: Object list - show selected count only if something selected
- 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
- Free & Pro: Data diff - fix failure if more than one column is missing on the other side
- Free & Pro: Apply zoom to almost all dialogs (except unknown error and initial activation dialog)
- Free & Pro: Handle settings reading error on app start
- Free & Pro: Open database(s) icon updated to be the same as on the Home tab (without 'plus')
- 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: 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: Custom data diff - fix unknown error on specifying the same column twice (as left without pair vs right without pair)
- Pro: Batch data diff - don't generate scripts on delete cancellation
- 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: Query result diff - add result error tooltip showing the whole error text (useful if error is truncated)
- Pro: Query result diff - fix 'method not implemented' error on subsequent run
- Pro: Data diff - show selected counts only if any record selected
- Pro: What's new - 'license key is not valid for this update' notice
- 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 - 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: Data diff tab - save error log for unexpected error on tab open
- Free & Pro: Run data script dialog - new option 'Import existing autoincrement/identity values on INSERT'
- Free & Pro: MySQL, PostgreSQL - check for object/column names to be case-insentitive unique
- Free & Pro: SQL Server - fix recent db password save
- Free & Pro: EULA minor adjustments regarding location
- Pro: Fix command line password arguments processing
- Pro: Batch data diff - 'Changed columns' - ignore case and make 'Yes' for 'Other' data type
- Pro: Batch data diff - DL columns (foreigh key dependency level)
- Pro: Object list - DL columns with configurable visibility (foreigh key dependency level)
- 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
- 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: Msi - fix some cases of the broken shortcuts removal on uninstall (conflict with PostgreSQL tool)
- Free & Pro: MySQL - allow missing table create/update date to fix RDS Aurora MySQL compatibility
- Free & Pro: SQLite - don't fail on reading table definition with missing column data type
- Free & Pro: Access - providing more details on database engine connectivity error
- Free & Pro: Object list - Refresh implemented
- Free & Pro: Data merge dialog - handle connectivity failure on Run
- Free & Pro: Merge data dialog - allow window resize/minimize/maximize
- Free & Pro: Data diff - fix sorting in the right panel on columns having case-sensitive changes
- 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: Object list - fix 'Compare selected' for views
- Pro: Table structure diff - Case-insensitive match by name
- Pro: Custom data diff - allow window resize/minimize/maximize
- Free & Pro: Update hyperlinks, grids, text, selection look & feel
- Free & Pro: Do not consider table name difference as a table change (otherwise for example same columns but DBMS with vs without schema provides all changed tables)
- Free & Pro: Object list - object name hyperlink tooltips
- Free & Pro: Data diff - add 'Page'/'Paging' label
- Free & Pro: Toolbar online help button
- Pro: Scroll background changes indication - more pale colors, fixed Changed indication in the object list
- Free & Pro: Data merge - fix some script generation issues for system comma decimal separator
- Free: Allow custom data diff from toolbar and don't trigger it if no key on data diff (same way as in Pro but wihtout views)
- Free & Pro: Provide table definition text as pseudo-sql instead of csv
- Free & Pro: Database open dialog - take last data from recent list (dbms per side, rest of data per dbms)
- Free & Pro: Object list - show creted/modified coulmns as N/A if corresponding metadata can not be retrieved from DB
- Free & Pro: Fix comparison failure of MySQL/MariaDB tinyint(1) data type which is synonym of boolean, read such columns as a number the same way as other tinyint options
- Free & Pro: Data diff - fix merge script generation for changed case of column names and custom mapping
- Free & Pro: Database reload dialog
- Pro: Query result diff tab
- Pro: Export to Excel (Home, Object list, Data diff, Batch data diff, Query result diff, Table structure diff tabs)
- Pro: Table structure diff - compare data without mapping prompt, the same way as from Object list
- Pro: Settings dialog
- Pro: Custom data diff - deny Key and Compare mapping type if one sides has Other data type
- Pro: Object list - 'Open in Query result diff' item action
- Pro: Table structure diff - show native type name attributes (like size and so on, earlier was available only for SQLite)
- Pro: Home tab panels - show separate Batch data diff buttons for tables and views
- Pro: Object list - deny 'Compare selected' for items selected for the same database
- Free: Data diff paging and page merge confirmation
- Free: Object list - allow 'Compare selected' for items selected for different databases
- Free: Data diff - remove limitation on number of columns and primary key column count
- Free: Allow to compare data from table definition text diff
- Free: Home tab - allow show new/all/changed
- Free & Pro: Read Access files without Access (only DB engine needed)
- Free & Pro: Fix a number of issues of comparability and mergeability for SQLite blob, boolean and datetimes
- Free & Pro: Data diff - fix rare occasional ArgumentOutOfRangeException on open (was 'unknown error' before)
- Free & Pro: Fix a number of issues of comparability and mergeability between SQL Server, MySQL/MariaDB and PostgreSQL
- Free & Pro: Make Other generic type not comparable
- Free & Pro: Fix some cases of failures of script generation for numeric values MySQL target
- Free & Pro: SQLite - fix incorrect value retreival for tinyint negative numbers
- Free & Pro: Fix DateTime generic type detection for date/datetime SQLite native types
- Free & Pro: More light app icon (for dark theme)
- Free & Pro: Fix compatibility mode shortcut icon
- Free & Pro: Table text preview - add 'Primary Key' Yes/No column
- Free & Pro: Data diff - ingore case searching for compatible primary key columns
- Free & Pro: Open DB dialog - hide port for SQL Server to allow to connect with non-TCP protocols. Port can be specified with server using comma, like for SQL Server connection strings and MssqlMerge.
- Pro: Batch data diff - initial implementation
- Pro: Custom data diff - fix dialog open from toolbar
- Free & Pro: Initial public version
