KS DB Merge Tools
 
for MS Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
and MariaDB
for SQLite
 
for PostgreSQL
 

What's New

1.0.0, 2022-09-12
- Free & Pro: Help pages
- Free & Pro: Open database dialog - fix nullref error on 'Test connection' without DB name
- Pro: Open database dialog - ability to connect by SSH
- Pro: Custom data diff - fix type names
- Pro: Table structure diff - remove 'Open SHOW CREATE TABLE result' button (not applicable for PostgreSQL tool)
- Pro: Home tab - change 'Open database from path in clipboard' command tooltip to 'Open database from connection string in clipboard'
0.9.0, 2022-09-09
- Pro: CREATE TABLE script - include indexes
- Pro: Table structure diff - Indexes section (with indexes not covered by constraints)
- Pro: Initial support of Sequences
0.8.0, 2022-09-08
- Free & Pro: CREATE TABLE script - include unique, FK, check and exclusion constraints
- Free & Pro: CREATE TABLE script - fix COLLATE duplicates
- Free & Pro: CREATE TABLE script - fix column comments
- Free & Pro: Object list - don't generate DROP statement on new items merge
- 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)
- Pro: Table structure diff - Constraints section with all constraints except constraint triggers
- Pro: Table structure diff - deny column merge of there is only column order change
- Pro: Table structure diff - columns sort order type added (natural, by name, by key then by name)
0.7.0, 2022-08-09
- Free & Pro: Reading and showing column collation, in Pro shown as part of column Type
- Free & Pro: Support GENERATED STORED expressions (read, show, merge with new column, drop expressions)
- Free & Pro: Support GENERATED AS IDENTITY definitions (without sequence_options)
- Free & Pro: Support column comments
- Pro: Table structure diff - merge column type change, USING colname::typename for built-in types
- Pro: Table structure diff - merge nullability change
- Pro: Table structure diff - merge default value (set/drop)
0.6.0, 2022-07-27
- Free & Pro: Initial support for domain data types
- Free & Pro: Support for object identifier data types
- Free & Pro: Fix some failures of reading function overloads for PostgreSQL 11+
- Pro: Object list - fix Excel export
0.5.0, 2022-07-25
- Free & Pro: Support for range and multirange data types
- Free & Pro: Don't fail on function/SP overloads (same name, different arg count)
- Free & Pro: Npgsql reference updated (6.0.3 -> 6.0.5)
- Pro: Table structure diff tab - handle enum types properly (presentation and merge)
- Pro: Table structure diff tab - handle composite types properly (presentation and merge)
- Pro: Data diff - fix disablity to merge/delete for tables without PK and with custom key defined
0.4.0, 2022-07-20
- Free & Pro: Array types support (table definitions and data diff/merge)
- Free & Pro: Fix jsonb data merge
0.3.0, 2022-07-08
- Free & Pro: Support data types bit, bit varying, inet, cidr, macaddr, macaddr8, pg_lsn, pg_snapshot, txid_snapshot, tsvector, tsquery, 7 geometry types
- Pro: Data diff - fix broken sorting on primary key
0.2.0, 2022-05-17
- Free & Pro: License Info dialog - after trial/full key submission keep app in the pure Free mode until restart (previously some Pro features could become partially available and cause some errors)
- Pro: Home tab - add 'Diff profiles' section
- Pro: New tab - Diff profile editor, opened by click on loaded diff profile status on the Home tab
- Pro: Custom data diff - add 'Save to diff profile' option
- Pro: Custom data diff - minor label adjustments
- Pro: Query key columns dialog - add 'Save to diff profile' option
- Pro: Query result diff - 'Save to diff profile' option
- Pro: Batch data diff - optimize 'new only' calculation
- Pro: Batch data diff - calculate new/changed counts for views with defined key
- Pro: Batch data diff - 'Common primary key' renamed to 'Common key' and now includes keys defined in the diff profile
0.1.0, 2022-04-22
- Free & Pro: Initial public version