What's New
Prior to version 1.10.0, version title contains the link for Windows installer.
1.10.0, 2024-11-25
- Free & Standard: Pro renamed to Standard
- Free & Standard: Scripting - binary for Linux x64
- Free & Standard: EULA updated (more details on automated usage, removed redundant statement regarding terminal)
- Free & Standard: Verified compatibility with MySQL 9.0 and 9.1
- Free & Standard: Oracle, string/binary values SQL formatting - split by chunks with length of 1000 to fix SP2-0027 when running generated script with SQLPlus
- Free & Standard: Oracle, script generation - add slash delimiter after triggers, procedures and functions to fix merge out of app
- Free & Standard: Update libraries (including for MySQL/MariaDB, Oracle and PostgreSQL connectivity)
- Free & Standard: Scripting - /forcescriptrun parameter to prevent unintended merge/delete script execution, new related error code 10 'deny script run'
- Free & Standard: Scripting - new function SetOption, for now to setup text diff options and local cache folder
- Free & Standard: Scripting - unknown return code changed from 7 to 255, 7 is used now for 'not supported statement' error
- Free & Standard: Scripting - data merge/delete - logging improvements, new error code 8 'invalid object'
- Free & Standard: Scripting - new error code 9 'EULA not accepted' for Linux and related --accepteula parameter
- Free & Standard: Scripting - new LogTo(logConnectionString) parameter, false by default, currently affects database reading for Oracle and SQL Server
- Free & Standard: Scripting - update command line arguments parsing and help
- Free & Standard: Scripting - improve diagnostics of parsing errors
- Free & Standard: Scripting - fix local cache cleanup on completion
- Free & Pro: Verified compatibility with PostgreSQL 17
- Free & Pro: Verified compatibility with MariaDB 11.5
- Free & Pro: Verified compatibility with Access 2024
- Pro: Scripting / Automation support, new tools: XdbmsMergeCmd.exe to run and Script Editor application to simplify creation and troubleshooting of scripts
- Pro: Json export (in addition to Xlsx, 'Export' toolbar button icon and tooltip updated respectively)
- Pro: Settings, Misc tab - Reports section updated to specify default export format (xlsx/json)
- Pro: Settings - new 'Local temp folder' configuration on the Misc tab
- Pro: Id-Remap Merge - ignore child tables having multiple foreign keys on the same column (was causing unexpected error before)
- Free & Pro: Object list, Data diff, Text diff and Query result diff tabs - totals panel redesign: highlight counts of currenlty shown items according to the new/changed filters, other layout updates
- Free & Pro: Data diff - new toggle to show list of selected columns, disabled by default
- Free & Pro: Home tab - new button indicating that list of shown object types is reduced to show those which have new/changed items, suggesting to remove this filter (appears only in appropriate case)
- Free & Pro: Fix cases of splash screen jump for non-100% system display scale
- Free & Pro: Support email changed back to support@db-merge-tools.net (agreement, activation dialog)
- Pro: Home, Object list, Data diff, Text diff and Query result diff tabs - new Unchanged total count
- Pro: New 'Show only unchanged' toolbar button, applicable for Home, Object list, Data diff and Query result diff tabs
- Pro: New 'Last change below' and 'First change above' toolbar buttons, applicable for Object list, Data diff, Text diff, Query result diff, Batch data diff and Table structure diff tabs
- Pro: Data diff - fix 'Index out of range' unexpected error on 'Next change' for tables without common key and with result truncated by paging
- Pro: Postgres - update table indexes retreival
- Pro: Indexes - fix index match for Oracle databases
- Pro: Indexes - fix ignored UNIQUE index change
- Pro: Indexes - recognize as changed if match by table and columns but different index name
- Pro: PostgreSQL - exclude some indexes which are already counted as primary keys in table definition
- Pro: SQL Server, SQLite - fix recognition of Cascade foreign key option
- Pro: Settings - Text Diff renamed to Schema Diff and added option to match objects by schema and name
- Free & Pro: Views - recognize as changed by returned column names and data types (similar to tables)
- Free & Pro: Verified compatibility with MariaDB 11.4
- 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'
- 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: 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: Batch data diff - show 'use sys.dm_db_partition_stats' only if one of DBs is MS SQL
- Free & Pro: Postgres - optimize table columns reading performance
- Free & Pro: Postgres - optimize table and view columns reading performance
- Free & Pro: Fix table and view columns reading progress indication
- Free & Pro: Oracle - exclude materialized views and view logs from tables list
- Free & Pro: Oracle - cache potentially large object definitions on disk instead of memory (views)
- Pro: Don't load triggers for PostgreSQL, Oracle and MySQL/MariaDB, view triggers for SQL Server
- Free & Pro: Cache potentially large object definitions on disk instead of memory (MySQL, PostgreSQL and SQL Server views)
- Free & Pro: MySQL - data diff, fix processing of Geometry data types for MySQL 8.3 and 8.4
- Free & Pro: SQL Server - support open by connection string
- Free & Pro: Oracle - fix 'Value can not be null. Parameter name: key' APEX_040000 schema loading error on Oracle 11g
- Free & Pro: Oracle - Home tab, fix missing database name in header if used 'Open new application instance' for database opened previously using connection string
- Free & Pro: SQLite - update System.Data.SQLite library to the latest available 1.0.118 based on SQLite 3.42.0
- Free & Pro: Check for local cache folder existence on startup
- Free & Pro: Open databases dialog - Allow to drag & drop files to file name text boxes (Access and SQLite db files, SSH key files)
- Pro: Diff profiles (exposed in Home, new Diff Profile editor tab, 'Save to diff profile' options in Custom data diff dialog, Query key fields dialog, Query result diff tab)
- Pro: 'Compare indented' option for views in the Text diff and Object list tabs
- Pro: Data diff - Export all pages confirmation dialog
- Pro: Settings - 'Export all pages' data diff settings
- 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: Fix export of datetime values for Access and SQL Server
- Pro: Query result diff - PostgreSQL: if query fails with 'type unknown to Npgsql' error, make a retry with AllResultTypesAreUnknown enabled
- Pro: Query result diff - 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
- 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 rows 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 rows 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 row 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 row 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
