Patterns for filling in-memory databases with testing data

Question

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 tools to support this ect...

score 1 · Accepted Answer · answered May 23 '11 at 14:42

1

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.

answered May 23 '11 at 14:42

rsp

23,135
6
55
69

score 1 · Answer 2 · answered May 23 '11 at 14:46

1

I see two approaches:

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

answered May 23 '11 at 14:46

Persimmonium

15,593
11
47
78

Patterns for filling in-memory databases with testing data

2 Answers2