Visualize Structure Differences And Synchronize MS Access Databases
- Compare and synchronize the structure of MS Access databases
- Visualize the differences between databases
- Mapping of (renamed) database objects
- Includes a command-line utility
- MS Access version 2000, 2003, 2007 and 2010 are supported
As a MS Access developer, you very often work with a test database from where you need to apply the structure changes to the production database. This can be a tough job when your database is complex; the chances of errors while propagating structural changes increases proportionally with the number of database objects (such as tables). Datanamic SchemaDiff for MS Accessis is the answer.
Datanamic SchemaDiff for MS Access enables you to compare and synchronize MS Access database structures. The tool will give you the full picture of all structure differences. Once your database schemas are compared, you can view the differences and let the application update the destination database and make it identical to the source database. A wide array of comparison options let you control how the comparison is done. A command line utility is included. With this command line utility you can further automate your database synchronization process.
- 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.
Datanamic SchemaDiff for MS Access costs $ 199 for a single user license (EULA).
Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.
Operating System: Windows 10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Databases: MS Access 2000, 2003, 2007, 2010, 2013