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

What's New

1.5.1, 2024-02-16

- 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

1.4.0, 2024-02-06

- 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

1.3.1, 2023-12-15

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

1.3.0, 2023-09-05

- 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

1.2.2, 2023-07-20

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

1.2.1, 2023-07-14

- 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

1.2.0, 2023-07-13

- 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

1.1.3, 2023-03-06

- 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

1.1.2, 2023-02-02

- 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

1.1.1, 2023-01-18

- 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

1.1.0, 2022-12-03

- 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

1.0.1, 2022-11-18

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

1.0.0, 2022-11-16

- 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

0.4.0, 2022-11-09

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

0.3.0, 2022-11-07

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

0.2.0, 2022-10-11

- 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

0.1.0, 2022-10-06

- Free & Pro: Initial public version