- Multiple MS Access versions supported.
MS Access version 2000, 2003, 2007 and 2010 are supported.
- Cross database versions comparison.
You can for example compare (and synchronize) a MS Access 2000 database and a MS Access 2003 database.
- Database structure comparison.
Connect to two MS Access databases and compare the objects in those databases.
- Object mapping.
Mapping is used to connect the objects to be compared. Mapping of database objects in source and destination database is done based on names. If no object with the same name was found, intelligent routines are used to find out if an object must be mapped to an object with another name. It detects renamed database objects.
- Compare tables with constraints, indexes, relationships etc.
- Wide array of comparison options.
You can control what is compared and what is seen as a difference. Use the comparison options such as case insensitivity, ignore constraints and 30 other options, for that.
- Synchronize complete database or selected objects.
You can select the database objects you want to synchronize.
- Intelligent alter script generation.
Generated script handles object dependencies and preserves data.
- Generate reports with all structure differences.A detailed HTML report with all database objects differences can be generated.
- Synchronization options.
You can ignore table elements (specific constraint types etc) or descriptions for example, for synchronization.
- Clear comparison overview.
A side-by-side, colour-coded comparison overview makes it easy to pinpoint at a glance similarities and differences between two database objects.
- Summary of differences.
The summary includes objects in source but not in destination (or vice versa), identical objects and the totals of selected objects.
- Filtering of comparison results.
You can filter on object type and/or on the status (different, identical, only in source, only in destination) of the compared objects.
- Automate with included command-line utility.
A command line utility is included to automate your compare and synchronize process.
- Comparison projects.
Project-oriented which means that you can save your comparison plan to a SchemaDiff project. You can then use the comparison and synchronize settings the next time you need to compare both database.
See if Datanamic SchemaDiff for MS Access can help you: