Catalog.CodeProject.com

dbForge Data Compare for MySQL is a fast, easy-to-use tool to compare and synchronize data of MySQL databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options. It also allows scheduling regular MySQL data comparisons using command line.
 
Key Features:
 
1) Custom mapping of tables, columns, and views
You can manually map tables, their columns, and views, which can't be mapped automatically. This is helpful when you want to compare identical tables, views and columns 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 can be either executed against the Target database, or saved to a file, or opened in SQL editor.
 
4) 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. Such new features as Code completion and SQL Code Formatter are added. New enhanced features offer developers extended suggestion lists during the typing of SQL code and object information on different database objects. Profile formatting capabilities allow users to create new profiles and edit the existing ones easier than ever.
 
New improvements in dbForge Data Compare for MySQL, v4.0 include:
* Data comparison tool's new features:
- New data comparison reports now contain table data (not just a summary)
- Comparison of custom query results (along with tables and views)
- "One-to-many" objects mapping when addressing columns that were separated as a table in the target database
- Possibility to include objects into comparison by mask, which is useful when comparing groups of tables
- Full-text data search in comparison results
- Analysis of comparison results is improved: 'Hide unmodified columns' option, per-column difference counters are added
 
* New window docking system now allows switching between tool windows on Ctrl+Tab.