Comparison of MySQL structure synchronization tools
» 19 October 2012
Working with MySQL-supporting web projects, the developers sooner or later face a situation where the new tables and table properties are to be added to the existing project.
This operation can be performed manually, analysing the text dump bodies of the two tables. However, the manual procedure is time-consuming. It requires several following steps: dumping structure of a single database, dumping the structure of another database and then comparing them with a software like Winmerge or other console tools looking for the differences between them.
A special tool is required for quick synchronization with further and storing the update file in a separated location. Unfortunately, the popular HeidiSQL 7 manager is unable to compare the properties of the tables. It can only define the presence or absence of the source and target tables.
We have tried to compare some popular programs for MySQL structure synchronization.
Measuring the features set and convenience, the SQLyog 10 software has been admitted the best.