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