database tools

MySQL tools

MySQL

SQL

schema difference

Database Administrators, rejoice! Business owners and IT managers, take a note! Now there is no need to compare and synchronize databases run by MySQL manually, wasting valuable and quite expensive DBA’s time. SQLBalance compares different databases, highlights the differences and synchronizes them (if necessary) automatically. The program analyzes database contents line by line, object by object, searching for differences in database structure or contents. When any are found, they are highlighted. The information about distinct objects is displayed in the form of table and as a DDL script, so understanding the differences is very easy (two panels, all database entries are side by side). Then, the databases are synchronized. There are two ways to do it – object by object, which takes more time, but gives the administrator more control, or the entire database synchronization (with one mouse click via generated DDL script). The log of all changes is kept, so the administrator can always go back and look how the database was changed. SQLBalance requires very low system resources and disk space, yet runs so fast that it seems to break the speed of light barrier. And at 70 dollars per copy, this is the software that actually pays for itself and saves companies money, because the average pay for a Database Administrator in 2003 in the United States was $28.53 an hour.