dbForge Data Compare for SQL Server Overview
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.
Raise your ROI, buy dbForge Compare Bundle!
Main advantages of Data Compare
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
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.
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.
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).
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.