SQL Balance for SQLBase 1.2.0

Compare and synchronize databases controlled by SQLBase. Very fast!
Download

SQL Balance for SQLBase 1.2.0 Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Shareware
  • Publisher Name:
  • Desktop Software Ltd
  • File Size:
  • 2.2 MB

SQL Balance for SQLBase 1.2.0 Tags


SQL Balance for SQLBase 1.2.0 Description

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 developer's 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


SQL Balance for SQLBase 1.2.0 Related Software