troubleshooting Question

Automation of Testing SQL queries - QTP? Other?

Avatar of chuchilla
chuchilla asked on
SoftwareOracle DatabaseQuality Assurance
2 Comments2 Solutions1027 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros