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 will analyze 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.

Here are some key features of "SQL Balance for MySQL":

· Comparing databases on one or different servers
· Synchronous navigation between the database objects with corresponding scripts displaying
· Synchronous navigation between the database objects with displaying of the script, which will remove the differences
· A possibility of executing scripts, which remove differences object by object or all the differences at once
· A possibility of editing scripts and changing the order of their execution;
· A built-in SQL Script Editor with syntax highlighted
· Adjustable and easy-to-use interface
· A wide variety of variants for interface adjustment

Requirements:

· 3 Mb of free space on the hard disk

Limitations:

· 15 days trial

What's New in This Release: [ read full changelog ]

· The program was successfully tested on the server 5.1.x