Patterns for filling in-memory databases with testing data

I would like to know what would be the best way to fill in memory database for testing with test data - how to manage such data, how to make simple insert scripts, what are good t开发者_开发知识库ools to support this ect...

One possible approach is the one taken by DbUnit, which offers classes to export and import table content to and from XML files. You can use it to (re-)load your tables with a predetermined set of test data.

I see two approaches:

1. Generate data, with this for example
2. Use a subset of real data, that can be extracted with this, keeping referential integrity etc