Comparing number of new or changed records will provide you more information, but these operations are more time-consuming. You can compare not only tables, but also you can queries data. However, for queries 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.
.
Export to Excel
Export to Excel generates Excel reports for object list, data diff, batch data diff and table structure diff. Click the
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.
Support of password-protected files
You can open password-protected files using
toolbar button or "with password" link on the project tab:
You can save file open security options to an acdms file, which can be used later using regular Open File action or as a command line argument. It can be very convenient if you often work with the same protected files. You put your credentials only once, save acdms and use it without entering credentials anymore. However you should understand that everything, including passwords, is saved as a plaint text and this file must not be shared with other persons. "Use relative paths" option allows to save project file name in acdms file relative to acdms file location. For example, if you save your acdms file to the same folder with project, then you can move both project file and acdms file to some other folder without breaking acdms file. Next time you will open acdms in AccdbMerge Pro, it will search for project file in the same folder again.
Some queries that considered as updatable by Access also allow to merge data.
Here you can merge field definitions, field properties (such as input mask or validation rule), indexes and table relationships used by this table. Field definitions currently being merged without data, once you have merged some field definition, you can use table data diff to merge data for this field.
Field properties diff and merge requires loading additional data, which make file open process much slower. If you are not going to merge fields, then most likely you don't need to load field properties. This can be configured using application settings window.
You can compare and merge indexes and relationships from table structure diff window mentioned above. Also, relationships are presented as a separate group on the project tab, so you can observe all database relationships using object list window.
VBA project references are presented as a separate group on the project tab and you can compare list of application references in the object list window.
Object list, data diff and text diff views provide the following additional diff tools:
- total, new, changed and new+changed record/line counts,
- display selected row in the separate vertical side-by-side comparison panel,
- paging in data diff allows you to work with really large amounts of data,
- sorting in data diff will help you to arrange and find required records.
Below are the sample screenshots.
Object list view:
Data diff view:
Text diff view:
- By-character comparison inside changed rows for text diff view,
- Find tab - drill-down links to occurrence with focus on target row in the text diff view,
- Copy to clipboard support for text diff, object lists and table diff views,
- More stable handling of database locks during project load and object import,
- Open file progress dialog,
- Ability to load only particular object types.