Compare and synchronize data between MySQL databases using dbForge Data Compare for MySQL. In addition, Percona and MariaDB databases are also supported.
dbForge Data Compare for MySQL
offers a professional and well-designed user interface, with support for skins, shortcuts and other customizations. It comes with a tabbed interface, with the possibility to restore tabs from previous sessions.
Various parameters can be set when creating a new data comparison. Tables, columns or views with different names can be mapped, so that they can be compared correctly. Also, different object types can be excluded from the comparison. Comparison reports can also be generated in Excel and HTML format.
You are able to preview differences and examine them, before making any final synchronizations. Data can be grouped and filtered, with the possibility to exclude certain objects, and also view possible errors and data loses, which would occur when making synchronization. You are able to generate a script, and use it at later time for synchronization, and by using command line, you are also able to make automatic comparisons and synchronizations.
With the use of SQL editor window, you can view and edit scripts prior to synchronization, and also generate SQL queries. It supports code completion and formatting, and previewing of data. In data preview window, you can search for text, while data can be also grouped, sorted and filtered.
In conclusion, a professional tool for data comparison and synchronization
. It offers high performance also when it comes to comparing large databases, and it supports a large number of MySQL, Percona and MariaDB server versions.