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?
source to share
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.
- The current version of Super Smack looks like available here
I asked a similar question here on StackOverflow in February and the two above looked like the best options.
source to share
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.
source to share
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).
source to share