dbForge Data Compare for SQL Server!

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.

MssqlMerge is an easy to use diff & merge tool for Microsoft SQL Server databases. This tool allows to compare and import/export database objects and data between two databases. Supported SQL Server versions are 2005, 2008, 2008R2, 2012 and 2014.

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.

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 GUI with multi-connections supports virtually all JDBC drivers, including ODBC bridge, Oracle, MySQL, PostgreSQL, Firebird, HSQLDB, CsvJdbc, SQLite. And top of that, everything is open-source!

ApexSQL Diff is an SQL development tool that can compare SQL Server database tables, views, and all other SQL Server objects. Beside comparing and synchronizing live databases, it can also compare and synchronize native backups, ApexSQL snapshots, script folders, and source control projects. It supports Azure SQL Database and SQL Server on Amazon RDS. Database schema synchronization can be automated and scheduled unattended. Upon finished comparison, you’ll be able to export results into HTML, XML, and Excel. It also supports creating executable installation packages that user can run without installing any other software. »

CompareData is free for comparing table/view data.

SQL Examiner is an easy-to-use database comparison tool that quickly and accurately compares and synchronizes schemas of SQL Server databases, including stored in SQL Server 2008! With a few clicks of the mouse, SQL Examiner merges selected databases and delivers exact results by analyzing the dependencies between the objects and your data.The tool’s flexibility allows you to be as involved as you want in the development process, from step-by-step processing to full automation.

ApexSQL Data Diff is a SQL Server database comparison tool used to compare and synchronize database data. It also supports comparing SQL Azure databases, SQL Server on Amazon RDS, database backups, CLI. It can automate and schedule database migrations, propagate data changes from one environment to another, identify and repair lost and/or damaged data, perform row level recovery from SQL backups without restoring. In case something goes wrong ApexSQL Data Diff can reverse any changes made by automatically creating a backup prior to database synchronization. With this tool, you'll be able to create sophisticated reports to document the differences between your SQL Server databases and database backups and schedule your migration unattended, using the Command Line Interface. It also supports creating executable installation packages that user can run without installing any other software. »

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.

Table Diff is a smart database comparison tool for SQL Server that allows database administrators and software developers to identify and eliminate data differences between database tables. Table Diff works with tables that might be located on disparate SQL Servers, allows identifying data differences such as missing records and different records (records with matching unique key and at least one mismatching non-key attribute), and generating synchronization scripts in SQL. Table Diff also allows to quickly synchronizing rows, columns and cells values by simply right-clicking on the object to synchronize. Table Diff solves one problem very well, and does not cost a fortune. Table Diff works with SQL Server 2000, 2005 and 2008. Data comparison can be performed between different versions of Microsoft SQL Server (e.g. compare a table on a Microsoft SQL Server 2000 to a table in Microsoft SQL Server 2008 as part of a migration). »