KS DB Merge Tools logo KS DB Merge Tools
Documentation
MssqlMerge logo for SQL Server
aka MssqlMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

Table structure diff tab

  • Opened from: Object list, Data diff and Text diff tabs
  • Applicable tab-specific toolbar actions:
    • Export to Xlsx or Json
    • Jump to the last, next, previous, first change
    • Select all, none, invert selection on the left, all, none, invert selection on the right side
    • Merge left selected items to the right side, right selected items to the left side
    • Delete selected items on the right side, selected items on the right side
  • Applicable object types: Tables

This tab allows to compare definition of particular table:

for SQL Server, table structure diff tab annotated

Tab is divided into 5 major collapsible sections (Columns, Constraints, Indexes, Triggers and Change tracking) and bottom panel for selected item details. Here is explanation of changes highlight annotation on the above screenshot:

  • 1 Changed item ([AddressLine1] which has changed Nullability)
  • 2 New item ([ModifiedBy] and [Accuracy])
  • 3 Unchanged column with changed column order ([PostalCode])
  • 4 Changed column with changed column order ([City] which has changed Nullability)

Vertical toolbar between two panels contains additional tab-specific actions:

  • Open data diff for the current table
  • Open data diff for the current table filtered only to new and changed records
  • opens query result diff with select top 1000 records statement for this table
  • 'Open table definition as text' opens text diff tab with table script

Columns can be shown in the one of three modes:

  • Natural order - columns are shown in the order they were added to the database. Note that columns could be added in a different order like it is shown for column PostalCode on the picture above.
  • Sorted by name. In our example of PostalCode now this column will be shown side by side and without any highlighting as completely unchanged
  • Sorted Primary key columns followed by sorted all other columns. Similar to 'Sorted by name' but just primary key columns listed first.

Please note that merge/delete action may fail because of limitations caused by other objects such as foreign keys, existing data and so on. Please check the merge execution result for details.

Free version limitations:

  • The whole tab is not available

Last updated: 2024-10-21