Compare'EM!

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. You can save the detected changes as a report or SQL script to synchronize data.

SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast.

CompareData is free for comparing table/view data.

Easily compare access databases with AccessDiff. AccessDiff compares objects with the same name between two Access databases. It also detects missing objects in either the source or destination. Records are compared based on the primary key. If there is no primary key for a table, the comparison is performed on the Natural Key. After the database comparison is performed, the differences can be exported into several different formats.

Compares and synchronizes rows in tables (or views) for SQL Server and SQL Azure. World's fastest, most reliable, and convenient tool, which has lots options and superb user interface. With Optillect Data Compare SQL you can: analyze data difference in details; synchronize production database with development one; migrate data to new version of SQL Server or SQL Azure; generate T-SQL script for tables; generate optimum synchronization script. Optillect Data Compare SQL features: support for all SQL Server versions (2000, 2005, 2008, 2011, SQL Azure); automatic object mapping; compare all possible data types including data conversion; full data transfer or partial data synchronization; lots of options; WHERE clause to filter rows; generate optimum T-SQL script to update target database; generate INSERTs for particular tables or views (even for particular columns and rows); ultra convenient and stylish user interface. »

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. You can compare two different databases, like access and SQL 2000. It will also allow you to create snapshots of a database and compare a live database to an snapshot. A database structure viewer is included.