Tool to compare and synchronize MySQL data
Dbforge data compare for mysql is a fast, easy-to-use tool to compare and synchronize data of mysql, mariadb and percona databases. The tool provides clear view of differences between data, allows analyzing them, generates synchronization script and applies changes at a glance.
It also allows scheduling regular mysql data comparisons using command line.
Support of all mysql versions 3.23 8.
Support of mariadb, versions 5.5, 10.0, 10.
Custom mapping of tables, columns, and views
You can manually map tables, their columns, and views, which cannot be mapped automatically
This is helpful when a user wants to compare identical tables, views and columns with different names
Convenient comparison wizard
The comparison wizard helps you quickly select databases, include required objects in comparison and start the comparison
Full control of data synchronization
The tool generates the synchronization script, which can be either executed against the target database, or saved to a file, or opened in sql editor
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
Code completion and sql code formatter
These features offer the extended list of suggestions 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