Automation of Testing SQL queries - QTP? Other?
Posted on 2009-12-27
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