What's new in KS DB Merge Tools for Oracle 1.2.4
May 8, 2024
- Free & Pro: Database opening - read view by view dependencies to calculate views dependency level
- Free & Pro: Object list - merge/delete views by dependency level
- Free & Pro: Fix some cases on loading the first database to the left panel even if it was requested to be opened in the right panel
- Free & Pro: Fix 'Value can not be null. Parameter name: key' APEX_040000 schema loading error on Oracle 11g
- Pro: Data diff - Export all pages confirmation dialog
- Pro: Settings - add Data Merge and Data Export sections on Data diff tab
- Pro: Object list - DL (dependency level) toggle and column made available for views
- Pro: Excel exports without opening file - remove hour glass before report completion notification
- Pro: Fix unknown error tab navigation sequence of 'data diff' -> 'table structure diff' -> 'data diff' for one-side only table/db
New in KS DB Merge Tools for Oracle 1.2.3 (Apr 4, 2024)
- 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: 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: Query result diff - better error handling of database connection errors
- Pro: Text diff - new 'Show tabs and spaces' toggle
- Pro: Text diff - new bottom line implementation, with selectable text and fixed tabulation width
- Pro: Data diff - allow to compare string values in the separate text diff tab (the up-right arrow near column name in the bottom grid, useful for multiline values)
New in KS DB Merge Tools for Oracle 1.2.2 (Mar 14, 2024)
- Free & Pro: Recent database open only if one side has no saved password - fix missing password for other side
- 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
- 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
New in KS DB Merge Tools for Oracle 1.1.0 (Jan 31, 2024)
- Free & Pro: Fix broken Data Diff for binary keys
- Free & Pro: Data merge dialog - change 'Import existing IDENTITY' to 'Import existing identity, sequence or other..' and make applicable for these types of auto-generated primary keys
- 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: Object list - Drop tables by DL desc then by name, to avoid drop failures caused by foreign keys
- Free & Pro: Do not apply system schema filter for Id-Remap mapping tables
- Free & Pro: Data diff - display short binary values in single quotes (similar to sql presentation)
- 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: 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 Object List when other side db is not opened
New in KS DB Merge Tools for Oracle 1.0.1 (Jan 30, 2024)
- Free & Pro: Fix broken Data Diff for binary keys
- Free & Pro: Data merge dialog - change 'Import existing IDENTITY' to 'Import existing identity, sequence or other..' and make applicable for these types of auto-generated primary keys
- 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: Object list - Drop tables by DL desc then by name, to avoid drop failures caused by foreign keys
- Free & Pro: Do not apply system schema filter for Id-Remap mapping tables
- Free & Pro: Data diff - display short binary values in single quotes (similar to sql presentation)
- 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: 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 Object List when other side db is not opened
New in KS DB Merge Tools for Oracle 1.0.1 (Dec 11, 2023)
- Free & Pro: Data diff - fix ORA-01008 on paging for table with multi-column primary key
- 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: Fix app crash on unknown error during dialog open
- Pro: Fix 'Cannot call StartAt' unknown error on Batch data diff -> click on view name -> compare data
- 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 changes
- Pro: Encrypt command line passwords on opening database in the new app instance
- Pro: Opening database in the new app instance: fix lost 'Save passwords' (both for other side database and the newly opened one)
New in KS DB Merge Tools for Oracle 1.0.0 (Sep 6, 2023)
- Free & Pro: Data merge confirmation dialog - add comment for 'Import existing IDENTITY' option
- Free & Pro: Fix table/view columns case-insensitive-duplicates check
- Free & Pro: Improved logic of changes invalidation after objects merge and refresh
- Pro: Table triggers support
- Pro: Settings - new 'Table definitions' tab allowing to setup table schema diff options
- Pro: Object list - show special message on attempt to merge tables with column-order-only changes
- Pro: Support for All-in-one license