The ECT (Environment Comparison Tool) can compare two independent T24 databases and display field-level differences. The environments to be compared can be on the same or on different servers or hosts. A full-scale comparison can be performed on all tables of the database, while individual tables can also be selected for comparison in list or unique-type mode.
Two main methods of comparison are supported: ID-based or Content-based. The ID-based method compares the tables, record by record, looking for any differences between field values in the source and target environments. The Content-based method verifies parallel runs in terms of the correctness of data content. Here, certain fields can be ignored by placing them on an exception list. This method is designed to compare tables with different IDs based on data content by matching records based on content rather than identifier, and without impairing run time.
This software is excellent for tests where results can be easily compared to the live status (e.g. service-pack change or upgrade, interface testing, or patches where a central software element is changed). Using this method, development results can be easily checked. Another important function of the ECT application is consistency checking following BCP and DRP tests.