The DataWeigher is the tool to compare and synchronize data. You can select any tables and fields from two MS Access databases and the DataWeigher finds differences. The comparison result is very visual, each type of records (added, deleted, changed) has its own color.
Whether you need to simply compare two databases or set up replication, you have come to the right place. Replicator does not change the reference database in any way nor requires setting up customs agents or triggers in your databases.
A powerful SQL tool to transform or reverse complex queries (generated by OBIEE, Microstrategy, Cognos, Hyperion, Pentaho ...) into diagrams to ease visualization and analysis. A graphical query builder that permits to create complex SQL queries easily.
The StarInix Database Compare application will allow you to compare the structure of two databases and display all the differences between them. Supported databases include: SQL Server (All Editions), MySQL and Access databases.