<div>
<div class="content wysiwyg-content">
I've got a large buch of SQL queries just saved as text files. They are generally record counts, compating tables, looking for data anomolies, validating transformations that kind of thing. Been tasked with finding out if its possible to automate these scripts easily and if so what kind of tools are available to use. I've used QTP before and know that its possible to use database checkpoints and write some vb code to pass arguments etc, but I think this is mainly designed a UI tool rather than being able to run a batch of SQL scripts. Also there may be a licencing contstraint, so if I do suggest this tool, then has to be sold argument. Are there other easier/free tools out there? Is QTP gonna be the best, if so, why? cheers
</div>
</div>


I've got a large buch of SQL queries just saved as text files. They are generally record counts, compating tables, looking for data anomolies, validating transformations that kind of thing. Been tasked with finding out if its possible to automate these scripts easily and if so what kind of tools are available to use. I've used QTP before and know that its possible to use database checkpoints and write some vb code to pass arguments etc, but I think this is mainly designed a UI tool rather than being able to run a batch of SQL scripts. Also there may be a licencing contstraint, so if I do suggest this tool, then has to be sold argument. Are there other easier/free tools out there? Is QTP gonna be the best, if so, why? cheers

Automation of Testing SQL queries - QTP? Other?

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Quality assurance (QA) is a way of preventing mistakes or defects in products and systems, and avoiding problems when delivering solutions or services to customers. QA is applied to software to verify that features and functionality meet business objectives, and that code is relatively bug free prior to shipping or releasing new software products and versions. Quality assurance comprises administrative and procedural activities implemented in a quality system so that requirements and goals for a product, service or activity will be fulfilled. Two principles included in quality assurance are: "Fit for purpose" (the product should be suitable for the intended purpose); and "right first time" (mistakes should be eliminated).

Quality Assurance

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.