I have the job of testing a windows 2000 app which links to an oracle db on unix box. The application is huge, many forms, windows, business rules etc... Testing this has become very repative and time consuming. I am looking for a tool which I could set up and run a lot of tests over night. I need some advice on the following questions. Can I get a tool which can do the following.
1) validation checking for example date formatting, type, invaild chars field lengths etc...
2) Repeat the same step many times during a test run but some times slighly changing the testdata. For eampple I don't want to have to spend ages editing data when I am only going to add and amend customer details several times.
3) Ability to carry on testing if a fatel error occurs.
4) Alot of my app disables features depending on who is logged on a which area of the app they are using or the status of a customer. How can i test that the menu buttons have been disabled and enbled without me being there looking at it.
5) the ablity to run the test over night and look at the results the next day. Simple reporting of faults and issues and successes would be ideal.
6) I don't want the company I work for to part with a lot of cash if tool is not up to the job. So are free trial versions of a tool available.
A side issue is that this app will need to be tested under pressure with many users using the system access and saving vast amounts of data. Would a seperate tool be better for this. If yes which one.
Sorry for all the questions but I am new to this area and need as much info as possible soon as possible. Any advice and pointers would be fanastic.
One more thought. Is this the only application that you will be testing with the tool that you buy? Probably not. It may be better to look at all of the major applications within your organization and compile a list of requirements as you did here (W2K, Oracle DB on Unix). It is hard to see how your organization can cost justify buying a tool just to test one application, unless that is the only application that your company has. You are also probably looking at buying a suite of tools to accomplish what you want. You also said that a side issue would be performance testing (although many would not consider that a side issue), and from my knowledge of performance testing tools, they do not have built in functionality to do the types of checking that you want. Although you could probably code the scripts to do that, it would be a lot easier to buy a separate tool.
Some tools have a lot more available than just testing, for example the Rational toolset also has Clearcase and Clearquest available which will enable you to manage your code releases and report defects, etc.
Click on the links on the left to get to all the major vendors, this helps this site as well.
in a quick look at your question i didn't notice if you specified what programming languague your application under test (aut) was written in. In assuming you have a gui to work with, you should then eliminate which vendords will work for you.
good luck in finding a vendor who supports foxpro, centura, etc...