Automatically generated test data in DB from schema?

I have discussion-db and need a large amount of test data for different sized samples. Please see the ready-made SELECT, JOIN and CREATE queries, scroll down the link.

  • How can I automatically generate test data in db?

  • How do I generate test data in different sample sizes?

  • Is there a ready-made tool?

+2


source to share


4 answers


Here are some suggestions for free tools that generate test data:

  • Databene Benerator : Supports many brands of database that support JDBC, Uses DbUnit GPL compliant XML format.

  • Super Smack : Originally a load testing tool for MySQL, it also supports PostgreSQL and includes a mock data generator.



I asked a similar question here on StackOverflow in February and the two above looked like the best options.

+5


source


I know this question is very dated, but I was looking for an answer to this exact question today and I came across this:

http://wiki.postgresql.org/wiki/Sample_Databases



Of the options listed (including built-in tools like pgbench), pgFoundry has several compelling options that work great for the test cases I'm working on.

I thought it might help someone like me, so this is it.

+1


source


I'm not sure how to get the auto-generated data and insert it into the database (I'm sure you could do it with a python script or something like that), but if you're just looking for infinite plaques to insert into db, this one should be helpful.

0


source


I'm not a post-resident, but in many other databases I've used, a simple mechanism for generating a lot of test data is cross join. This technique is especially useful for generating large amounts of test data.

Here's a good blog post (especially for SQL Server).

0


source







All Articles