File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes tool to generate test data? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "tool to generate test data?" Watch "tool to generate test data?" New topic

tool to generate test data?

Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

I have an excel spreadsheet of about 1300 rows. This is representative data of what a million row table looks like. I need to generate more rows like the ones I have.

Is there a free tool, that works with mySQL that can help me with this?
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
Huh? I'm not following you here. 1300 rows represents millions?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32819

I don't know if any tool like that exists. It would have to have some understanding of your data. You could write a simple Java (or Perl or ...) to mix the rows or generate random variations.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
It is sorta covered in the JavaRanch Style Guide.
subject: tool to generate test data?
It's not a secret anymore!