SQL Balance for SQLBase 1.2.0

SQLBalance for MySQL is a powerful utility for DBA, which allows to compare and synchronize the structure of different databases, controlled by MySQL server.

Databases, which you wish to compare, may be located on different servers. This utility may turn to be extremely useful when, for example, it is necessary to transfer the changes from the developers local database to the common database of the company.

As a rule, this procedure turns into the routine many-hour reviewing and comparing of the changed scripts, and after that - manual forming of the synchronization script. During this process there can appear mistakes, which are not always easily found.

SQLBalance for MySQL helps to solve this problem. It accomplishes this task in the following way:

1) It reads the structure of databases, builds the tree of object correspondences of the compared databases, marking differences by the different colour.

2) Shows full information about the object in the form of the table and as a DDL script.

3) Forms the DDL script, which removes differences between chosen objects of the compared databases or in the whole database. DBA can perform synchronization object-by-object and in the whole database. Besides, the program keeps a detailed log of the performed operations.

Database Administrators, rejoice!

Business owners and IT managers, take a note! Now there is no need to compare and synchronize databases run by SQLBase 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 120 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.