up vote 1 down vote favorite
1
share [g+] share [fb]

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content.

Given a database DB(S, D) consisting of the database schema S (everything described with DDL (tables, columns, constraints,...)) and data D (the actual data in the db, everything described with DML), a query Q and a result set R that is the result of the query when run on the DB. In pseudocode:

R = runQuery(Q, DB(S, D))

Is there a tool which can generate data D2 such that I get the same result set R with query Q?

D2 = generateTestData(S, Q, R)
R2 = runQuery(Q, DB(S, D2))

assert(R == R2)

Is this possible in general? Can toad generate these insert statements?

link|improve this question
A very general and complicated problem. But I think I have an idea for something else: generateTestData(Q, DB(S, D)). Would it be of any use in your situation? – kubanczyk Dec 2 '11 at 19:24
Yes, this would also be interesting. Could you please describe in more detail. (Sorry for the late reply.) – Ben Dec 12 '11 at 11:57
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.