User Mark Vontsolos (firstname.lastname@example.org) posted:
I am looking for an application similar to Compuware's FileAid/CS that will
enable me to create test data based on data that is within an existing
database. I want to be able to specify that I have ten records in a table
that will meet certain criteria. It needs to maintain all the referential
integrity that is in the original database.
The application also needs to be capable of comparing two databases and
If anyone knows of a decent application that has this functionality please
let me know. Also if anyone has any experience with FileAid, I would like to
hear your opinion.
My experience with file aid was mixed. It did have some useful stuff, but
when I was trying to work on a particular DB (can't remember might have
been Sybase) the version I had did not handle indexes.
At present I use Rational Robot to enter stuf into the application from an
excel spreadsheet saved as a csv file. To be honest for the application I
am working on it is the best way of doing it, and file aid would not be.
It is also quite good as putting data directly into tables assumes the
application handles this properly, whilst populating via the application
tests that as well.