DBUnit automatic dataset generation

Question

I have seen a couple of question regarding creating datasets in DbUnit here on StackOverflow, but all of them were regarding export data from existing tables.

My question is, can DBUnit create some dummy dataset basing on my database schema? I don't care whether the strings would be like "ZDSFFDSDGF" and BLOBS would be just garbage. I just need some test data and I'd prefer to spend my time developing instead of populating my tables.

Any solutions, pointers? A Netbeans plugin doing that would be just great, but I guess this is just a wishful thinking...

Fenland

Answer 1

You could use a database mock data generator to feed your database and then dump the table content with DBUnit. I have experience with dbMonster and databene benerator (see this previous answer).

I would actually recommend the later in your case because it can create database snapshots directly in DbUnit format. There is an Eclipse plugin but sadly nothing for NetBeans AFAIK.

UPD. 2016: The eclipse plugin is discontinued.

Hothead

Need to explore that, but at first glance it looks great. Thanks! – Fenland