Functional check of software product to database cooperation

The Case

Your QA department tests the functionality of the software product, implementing operations with databases. In the process of its operation this software product changes, adds or deletes data in the database.

In most of the cases the checks are intended to prove the accuracy of executing complete and multi-stage operations, changing data in databases.

Normally, after each cycle of test operations, a QA department worker tests the contents of different database tables. The number of these tables is often measured by dozens.

Thereby the checking procedure becomes very time consuming and may cause errors originating from the human factor.

Main goals to be achived

• to improve the quality of the software product to database cooperation check;
• to reduce the time needed for the test of the software product's operation;
• efficiency and simplicity of checking procedures and eliminating the possibility of human factor;

Our solution is

Use Cross-Database Comparator Pro 6.0 or Cross-Database Studio 6.0 in order to compare a "regression" database with an "test" database:

1. A "regression" database corresponding to the correct result of the software product operation is created. These "regression" databases are developed for each stage of the software product operation upon the demand.
2. Upon the completion of all the required functionality with the tested software product the "test" database is compared with the "regression" database, which accords with the current stage of tests, in order to get a detailed report about the found differences in table structures, primary keys, indexes, foreign keys, store procedures, data (the list of the objects of comparison is defined by perforce)
3. The received reports are analyzed in order to take decisions about the further steps. If the found difference between the databases is dramatic – act to change the software product, or make any other actions, in accordance with your profile.

Advantage of our solution

• provides a significant speed-up in the software product test analysis procedures;
• improves the quality of the software product to database cooperation check;
• eliminates the possibility of human error.