Reviewer, 2007-10-18 07:54:00

Looking for a database synchronization and comparison tool? Well, you cannot get a better or more user-friendly one than EMS DB Comparer for InterBase/Firebird. This software allows you to compare various database objects and view all the differences as well as eliminated all or selected differences using an automatically generated script.

The EMS BD Comparer allows you to work with a lot of projects simultaneously, define the parameters for comparison, change modification scripts, and even print difference reports. The differences discovery and elimination processes are simplifies by the software’s extremely user-friendly interface, which not only leads to less hassles of database comparison but also helps save time and money. As mentioned above, you can use this software to compare and synchronize several schemas or databases both on the same and on different servers. Further, you can customize the comparison options to suit your needs and compare only select properties of the database objects. The Compare Options menu includes two options, one for selecting objects for comparison and the other for selecting fields. The list of objects that can be selected includes domains, tables (fields, constraints, and indices), views (fields and triggers), procedures, UDFs, exceptions, generators, roles, blob filters, and triggers. And, the field compare options menu let you set from a list of twelve compare properties and three script generation options. You can also select the fields you want to filter through this menu. And, the option selection process is quite simple; all you need to do is select or deselect the checkbox against each option.

Once the comparison is complete, the differences between databases are displayed in an easy-to-comprehend and user-friendly manner along with the details and modification scripts for various objects. Moreover, it also has a built-in SQL Script editor and the database differences report can also be customized. All in all, giving the EMS DB Comparer a rating less than 4 would be absolutely unfair.