KS DB Merge Tools
by Konstantin Semenenkov
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
 
for SQLite
 

Batch Data Diff

Batch Data Diff allows to compare data for multiple tables and views. This tool can be opened using 'Batch data diff (Ctrl+Shift+B)' toolbar button:

With click on any calculated count you can drill-down to data diff to check these records. For views new and changed records count can not be calculated since they do not have primary keys and therefore it is not possible to detect whether the record was added or changed.

Query Result Diff

With 'Query result diff (Ctrl+Shift+Q)' you can compare arbitrary query results (note that application zoom was applied to keep control layout for little screenshot size):

This can be convenient if you want to specify some column or row filter. You can split this window to specify two queries and compare their result, in this case you can also run both queries against the same database.

You can run number of data retreival statements of stored procedure call that would return multiple resultsets. After execution you can scroll thru these resultsets using resultset counter.

Note that query results can not be merged.

Custom Data Diff

With 'Custom data diff (Ctrl+Shift+C)' you can compare any tables and views with ability to specify custom field mapping. At least one field mapping item must be defined with mapping type 'Key':

This dialog also can be opened from the regular data diff window by 'Field mapping' link and from query result diff in 'customize field mapping' mode.

Export to Excel

Export to Excel generates Excel reports for object list, data diff, batch data diff, query result diff and table structure diff. Click the 'Export to Excel (Ctrl+Shift+E)' toolbar button to export data grid from the currently opened tab:

For the data grids that allow record/object selection (such as table diff view), only selected records will be exported, if any records were selected.

Extended diff facilities

As you could notice on the Overview page - object list, data diff and text diff views provide the following additional diff functionality:

  • 'Next change (Alt+Down)' and 'Previous change (Alt+Up)' toolbar buttons to search for the next/previous block of changes in the data diff and text diff views.
  • total, new, changed and new+changed record/line counts,
  • display selected row in the separate vertical side-by-side comparison panel at the bottom of the window. For text diff it also provides by-character comparison,
  • paging in data diff allows you to work with large amounts of data,
  • sorting in data diff will help you to arrange and find required records.
  • No data diff and merge limitations

    MssqlMerge Free provides basic data diff and merge facilities with the following limitations:

  • both tables must have compatible single-column or two-column primary keys,
  • no more than 50 columns
  • Views data diff

    You can compare view results the same way as for tables using 'Compare data' and buttons. Click on these buttons will bring up a 'Define query key fields' dialog with the list of common fields. Select number of fields that can uniquely identify query row to detect new and changed records. When you click OK, MssqlMerge Pro checks that chosen fields match this criteria, otherwise you will get a warning and will have to select other fields.

    Command line arguments

    You can open projects in MssqlMerge Pro using command line arguments. For this you need to same your database connectiviry settings to *.msdbs files, this should be done from 'Open databases..' dialog. The format of command line arguments is

    mssqlmerge.exe left_msdbs_path right_msdbs_path

    More object types

    In Pro you can compare user-defined table types, and you can both compare and merge table default constraints, check constraints, unique constraints, indexes, foreign keys and triggers.

    Other enhancements

  • Customization - you can setup lot of options in Settings window - what and how to compare by default.
  • Find tab - drill-down links to occurrence with focus on target row in the text diff view.
  • In object list and Batch Data Diff you can use 'Filter (Alt+F)' command to filter object names by substring. This can be very convenient for large lists.
  • Copy to clipboard support for text diff, object lists and table diff views.