SQL Balance for MySQL 2.0.1
Publisher's Description:
SQL Balance for MySQL - 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.
Latest Changes:
The program was successfully tested on the server 5.1.
Social bookmarks:
RSS: 
Latest User Reviews:
Version: 2.0.1
Error in script generations
Although this software has a lot of the bells and whistles, it lacks in accuracy of the script generation. When I was attempting to take an old database and bring it up to date to the new database model, it created the scripts to run to do so; However, the scripts were mostly wrong. I had to manually edit a good 80% of all scripts so that there was no MySQL errors or that things were executed in the correct order.
An example is the script trying to drop columns and then trying to remove the primary key to that column. Another problem being it added things needlessly making the script wrong such as 'drop foreign key add foreign key ....' when it should of just read 'add foreign key'. or 'alter XXX table set ...' when it should of read as just 'set...'.
Social bookmarks:
RSS:
Audio & Multimedia
Business
Accounting & Finance
Yhen
2006-12-22 13:15:22
