What's new in MssqlMerge 1.29.0
Apr 28, 2024
- Free & Pro: Table definitions - recognize column collation
- Free & Pro: Table definitions - recognize column xml_schema_collection and related DOCUMENT xml data type attributes
- Free & Pro: Open database dialog - 'Use connection strings' option
- Free & Pro: Open database dialog - test connection
- Free & Pro: Open database dialog - labels and layout updated
- 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: Database opening - read view by view dependencies to calculate views dependency level
- Free & Pro: Object list - merge/delete table definitions and views by dependency level
- Free & Pro: Object list - delete table definitions by dependency level
- Pro: Support for XML schema collections
- Pro: User-defined table types - recognize column xml_schema_collection and related DOCUMENT xml data type attributes
- Pro: User-defined table types - recognize column collation
- Pro: Object list - DL (dependency level) toggle and column made available for views
- Pro: Data diff - Allow to compare xml values in the separate text diff tab
- Pro: Home - 'Open database from connection string' now uses connection string as is instead of parsing server, credentials and db
- Pro: Opening database in the new app instance: fix lost 'Save passwords' (both for other side database and the newly opened one)
- Free: Home - 'Open database from connection string' made available
New in MssqlMerge 1.28.4 (Apr 5, 2024)
- 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 false-positive changes caused by internal approximacy for floating point data types
- 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 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 MssqlMerge 1.28.3 (Mar 20, 2024)
- Free & Pro: Object list - merge / replace / 'compare selected' deny reason tooltip - add 'with loaded definition' to avoid confusion regarding blocked action for grayed object titles (which have no definitions loaded, because of permissions or WITH ENCRYPTION)
- 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
New in MssqlMerge 1.28.2 (Mar 13, 2024)
- Free & Pro: Recent database open only if one side has no saved password - fix missing password for other side
- 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 MssqlMerge 1.28.1 (Mar 2, 2024)
- 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: Fix 'Full screen' toggle state if changed by F11
- Free & Pro: Fix 'It is an expired trial key' key entry error presentation
- Free & Pro: Data diff - use the same fonts in the merge/delete progress as in other places
- 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: Fix cases of broken Ctrl+C in the new text editor (Query result diff, etc.)
New in MssqlMerge 1.28.0 (Feb 14, 2024)
- Free & Pro: SQL Syntax highlight in the Text diff, Object list text preview, Table structure trigger text preview, View definition text preview, Merge dialog and Query result diff
- Free & Pro: Home tab - 'Copy all' database progress actions appearing in case of errors
- Free & Pro: Ability to switch to the full screen using F11 shortcut
- Free & Pro: Reduce cases of duplicated ';' in generated scripts
- Pro: Id-Remap Merge dialog - fix occasionaly broken table order by name for same DL
New in MssqlMerge 1.27.1 (Jan 25, 2024)
- 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
New in MssqlMerge 1.27.0 (Jan 23, 2024)
- Free & Pro: Data merge dialog - change 'Use _IDENTITY_INSERT..' 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: 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 Object List when other side db is not opened
New in MssqlMerge 1.26.2 (Dec 9, 2023)
- Free & Pro: Unsaved password prompt on opening recent item - fix focus on password control if 'Display passwords' is enabled
- 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: Home tab - indicate that recent database requires password entry (sql server protection type without saved password, not a saved msdbs)
- 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
New in MssqlMerge 1.26.1 (Sep 27, 2023)
- Pro: Object list - show 'Open table definition as text' for new tables
- Pro: Object list - show 'Open view definition as text' for new views
- Pro: Batch data diff - fix 'An item with the same key has already been added' on merge script generation
New in MssqlMerge 1.26.0 (Sep 13, 2023)
- Free & Pro: Table definition merge confirmation dialog - minor label adjustments regarding Data diff
- 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: Support for view indexes and triggers
- Pro: New 'View definition diff' tab for views, similar to 'Table structure diff' tab for tables to manage view indexes and triggers
- Pro: Home - 'Show table indexes' and 'Show table triggers' changed to show 'table and view' indexes/triggers
- Pro: Settings - new 'View Definitions' tab
- Pro: Object list - new 'Open view definition as text' action for views
- Pro: Text diff - new 'Open view definition' action for views
- Pro: Batch data diff - populate startup data in the background and fix occasional DispatcherUnhandledException unexpected error for large lists
- 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
- Pro: Home tab - 'Show table constraints' changed to 'Show foreign keys'. Check, unique and default constraints are no longer listed separately on the Home tab.
- Pro: Find tab - exclude CHECK, UNIQUE and DEFAULT constraints from search results as separate items (should be covered by Tables search results)
- Pro: Remove constraints from table definition diff settings (always take constraints into account)
- Free: Support for Schemas
New in MssqlMerge 1.25.0 (Jun 29, 2023)
- Free & Pro: Update code sign certificate (may cause smart screen warnings)
- 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: Data merge - in case of INDENTITY_INSERT failure show the reason in the first script item result of that table
- Free & Pro: Home tab, database open - 'Close both' progress action (useful if both progresses have errors)
- Pro: Batch data diff, merge new and changed - add option to delete target records missing in source
- Pro: Batch data diff - fix merge failure caused by multiple IDENTITY_INSERTs
- Pro: Data merge - fix ignored disabled INDENTITY_INSERT for Copy ALL and Save ALL actions
- Pro: Object list - show selected count only if something selected
- 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
New in MssqlMerge 1.24.6 (Mar 16, 2023)
- Free & Pro: Object list - if some selected object can't be merged (for example table with excrypted trigger), allow to merge remaining selected objects, with a new error dialog
- Free & Pro: Handle settings reading error on app start
- Free & Pro: Unknown error dialog - minor label adjustments
- Pro: Custom data diff - fix unknown error on specifying the same column twice (as left without pair vs right without pair)
New in MssqlMerge 1.24.5 (Feb 27, 2023)
- Free & Pro: Apply zoom to almost all dialogs (except unknown error and initial activation dialog)
- Free & Pro: Data diff - fix non-closeable progress on merge/delete script generation failure
- Free & Pro: Data diff - fix occasional 'index out of range' error on merge/delete all pages for table with changed columns
- Free & Pro: Data diff - save error log for unexpected error on tab open
- 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: Parallel database open - improved progress completion responsiveness
- 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: EULA minor adjustments regarding location
- 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
- 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
- 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: Query result diff - add result error tooltip showing the whole error text (useful if error is truncated)
- 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: Table definitions - read and compare check, unique and foreign key constraints
New in MssqlMerge 1.24.4 (Jan 24, 2023)
- Free & Pro: Open database dialog - add recent servers to db server dropdowns, with username if any; populate relevant fields (with password if was saved) on drowpdown item selection
- 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
New in MssqlMerge 1.24.3 (Jan 14, 2023)
- 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)
New in MssqlMerge 1.24.2 (Jan 6, 2023)
- Free & Pro: Allow merge only if there are any new or changed item (deny if all items are unchanged)
- Free & Pro: Data diff - case-insensitive primary key column match
- 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
- 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 (foreign key dependency level) column for tables with configurable visibility
- Pro: Object list - merge tables by DL order
- Pro: Object list - show 'only column order changes' dialog for the relevant merge scenario
- Pro: Table definition merge - in case of ALTER COLUMN re-create constraints to fix 'failed because one or more objects access this column' error
- Pro: Table definition merge - fix default constraint merge for case named vs system-named
- Pro: Table definition merge - fix identity change merge when it is combined with add/drop other columns
- Pro: Table structure diff - case-insensitive match by name
- Pro: Merge objects dialog - new 'Save to file' action for script and execution result
- 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: Custom data diff - allow window resize/minimize/maximize
New in MssqlMerge 1.24.1 (Dec 6, 2022)
- Free & Pro: Data merge dialog - handle connectivity failure on Run
- Free & Pro: Object list - handle connectivity failure on Refresh
- Free & Pro: Database open progress - fix duplicate connectivity errors (list just once)
- Free & Pro: Database open progress on table definition merge or table list refresh - clarify multiple "Calculating changes" with object type name
- Pro: handle copy to clipboard error (clipboard can be busy with some other app, https://stackoverflow.com/a/68857/282694)
New in MssqlMerge 1.24.0 (Nov 29, 2022)
- Free & Pro: Update hyperlinks, grids, text, selection look & feel
- Free & Pro: Verified SQL Server 2022 compatibility
- 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: Data diff - fix rare occasional ArgumentOutOfRangeException on open (was 'unknown error' before)
- Free & Pro: Toolbar online help button
- Free & Pro: Data diff - add "Page"/"Paging" label
- Pro: Scroll background changes indication - more pale colors, fixed Changed indication in the object list
- Pro: Query key fields and Custom data diff dialogs - case-insensitive column match
- Pro: Data diff, Excel export - output signed and unsigned byte-sized numbers as numbers, not as text
- Pro: Home tab - change 'Open database from path in clipboard' command tooltip to 'Open database from connection string in clipboard'
- Pro: Settings - Database open/reload label adjustments
- 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
New in MssqlMerge 1.23.1 (Sep 3, 2022)
- Free & Pro: Normalize default expressions to avoid double parenthesis and changes like ((0)) <> (0)
- 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)
New in MssqlMerge 1.9.6 (Mar 1, 2021)
- Free & Pro:
- Open dialog usability fixes (tab order, saving Save/Load expanded state)
- Start license dialog keyboard navigation improvements, updated Help text
New in MssqlMerge 1.9.5 (Oct 30, 2018)
- Free & Pro: Object list merge - fix hide of other object types
- Pro: Query result diff - remove command timeout, show execution time, add Field Mapping button, add access keys
- Pro: Batch data diff - add access keys, add F5 shortcut to Run
New in MssqlMerge 1.9.4 (Oct 26, 2018)
- Free & Pro: Project tab - use grid to show counts
- Free & Pro: Improve database reading performance
- Free & Pro: Project tab - 'reload' action
New in MssqlMerge 1.9.2 (Oct 15, 2018)
- Pro: Quick filter (Alt+F) for Object List and Batch Data Diff
- Free & Pro: Data diff - 'Case insensitive' and 'Ignore whitespace' string compare options
- Free & Pro: Misc. keyboard manupulation improvements (switch panes, selection from object list, data diff, batch data diff)
- Pro: Batch Data Diff - more responsive progress
- Pro: fix 'Selected fields are not unique in the left project' message for error on the right project
New in MssqlMerge 1.7.0 (Jul 3, 2018)
- Pro: Table indexes support
- Free & Pro: Text diff - show line numbers
- Pro: Text diff - sync horizontal scroll in bottom panel
New in MssqlMerge 1.6.0 (Feb 15, 2018)
- Pro: Check constraints support
- Pro: Default constraints support
New in MssqlMerge 1.5.1 (Jan 25, 2018)
- Pro: Project tab - drilldown to batch data diff
New in MssqlMerge 1.5.0 (Nov 27, 2017)
- Free & Pro: Object lists - adjust Name column width to take more available space
- Pro: Foreign keys support
New in MssqlMerge 1.2.0 (Feb 24, 2015)
- Free & Pro: data diff & object list - record deletion
- Free & Pro: for narrow data grids - select row on click outside of table columns
- Free & Pro: object list - fix error "'System.Windows.Documents.Run' is not a Visual or Visual3D"
- Free & Pro: close dialogs on Esc
- Free & Pro: minor DB loading progress improvements
- Pro: custom data diff
- Pro: updated comparison logic for geo & sql_variant data types
- Pro: fixed excel output for datetimeoffset, hierarchyid, time and uniqueidentifier
- Pro: batch data diff - combined columns Primary Key & Common Key
- Pro: batch data diff - fixed broken column labels
- Pro: excel export - include DB name in project label
- Pro: object list & batch data diff - move prev/next change
- Pro: batch data diff - show all/new/changed
New in MssqlMerge 1.1.0 (Feb 24, 2015)
- Pro: data diff for views
- Pro: fixed click on view name from batch data diff (join keys are not required to show the sql text view)
New in MssqlMerge 1.0.0 (Feb 24, 2015)
- Free & Pro: SQL Azure support
- Free & Pro: object list - fixed "duplicate key" error on selection
- Free & Pro: improved DB connection failure handling
- Free & Pro: installation package
- Pro: batch data diff
- Pro: no data diff limitations
- Pro: Previous/Next change buttons for text diff and data diff
- Pro: selected row diff in the bottom for object list, text diff and data diff
- Pro: changes summary for object list, text diff and data diff
- Pro: paging for data diff
- Pro: drill-down from Find window to the object definition
- Pro: save db settings to *.msdbs files (with command line support)
New in MssqlMerge 0.1.5 (Feb 24, 2015)
- Error handling for objects retrieved by sp_helptext (i.e. all except tables)
New in MssqlMerge 0.1.4 (Feb 24, 2015)
- Data merge
- Batch selection for new / changed / new+changed views
- Data diff - exclude timestamp values from data comparison
- Data diff - detect comparable fields on exact data type equality