Data Compare is a fast, easy-to-use tool to compare and synchronize data of Microsoft SQL Server databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options.

Key Features:
1) Custom mapping of tables, columns, and schemasYou can manually map tables, their columns, views, and even the schemas, which can't be mapped automatically. This is helpful when you want to compare the following:Objects with different data structuresColumns of the objects with different data structuresIdentical schemas with different names
2) Convenient comparison wizardThe comparison wizard helps you quickly select databases, include required objects in comparison, and start the comparison. Also you can set up additional options.Following the wizard pages is convenient and guarantees accurate data comparison.
3) Full control of data synchronizationData Compare generates the synchronization script, which you can either execute against the Target database, or save to a file, or open in SQL editor.
4) Support of various SQL serversYou can compare data between the following SQL Server databases: SQL Server 2008, 2005 (including Express editions), and 2000 (including MSDE edition).
5) Integrated SQL editor Using SQL editor, you can view, edit, and execute synchronization scripts or create and execute queries.Data window offers a wide number of options for managing retrieved data. For example, you can use card and grid modes for better view; group, sort, and filter data in the grid; benefit from the cached updates option and more.