1. Overview

Query Tool for Bulk execution of SQL statements and Verification of expected results (i.e., regression testing)

The premise of the tool is that you run a test ("scenario"), which is one or more SQL statements ("query set"), and the results are then compared to the corresponding expected results, to confirm success or failure. An error file will be generated when the query fails to execute or when actual results don't compare to expected results. There will be several different levels of reports (i.e., individual query, query set and summary) produced.

The tool is easy to run one scenario at a time, but it's also designed so that you can run multiple scenarios in a single run. This enables you to organize your scenarios in folder groupings, and then run those groups against the same configured data source (i.e, database, application server, etc.).