Convert to TP?
On beginning employment at a new company I inherited a product regression test process that is partially automated via batch files. The product is browser based, but a vast majority of the testing is not related to the browser. The company owns licenses for TP, but it has not been utilized to automate testing of the particular product I'm responsible for.
The question I keep asking myself is, does it make sense to convert the batch file test framework to a TP testing framework?
The generic test process flows something like this:
- Populate SQL db with a specific product configuration using osql.exe/sqlcmd.exe
- Populate db with specific test data using osql.exe/sqlcmd.exe
- Execute in-house simulator program to forward test transactions to the AUT. The program relies on data contained in external text data files.
- Extract resulting test data from db to a results text file using using osql.exe/sqlcmd.exe
- Manually compare resulting test data to baseline test data using third-party differencing utility to determine differences
Since the current process relies heavily on external executables (osql.exe, sqlcmd, simluator.exe, third-party differencing app), does it make any sense to insinuate TP into the process? Honestly, I can't fathom it providing more functionality than the current batch files (all I can visualize is loads of scripts containing nothing more than countless Shell... statements) except that it will have a graphical front end.
As for browser testing, I can see loads of possibilities. But for backend testing....? No so sure.
Curious to know the thoughts of others in the group.
Re: Convert to TP?
Does your company also own Compuware's File-Aid C/S product? It is a test data managment tool that extracts, compares, loads, etc data in databases (SQL, Oracle, etc)
The combination of TP and FileAid might be what your looking for.