dbForge Data Compare for SQL Server
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 schemas
You 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 structures
Columns of the objects with different data structures
Identical schemas with different names
2) Convenient comparison wizard
The 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 synchronization
Data 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 servers
You 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.
Ссылка: http://www.deva..sql/datacompare/datacomparesql.exe
Key Features:
1)Custom mapping of tables, columns, and schemas
You 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 structures
Columns of the objects with different data structures
Identical schemas with different names
2) Convenient comparison wizard
The 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 synchronization
Data 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 servers
You 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.
Ссылка: http://www.deva..sql/datacompare/datacomparesql.exe
Видео: