Thomas Kestler - 2008-08-05

dbUnit is an OpenSource tool for database unit testing and offers export and import of database data to and from XML files. So it looks similar to JUDIE. But, there are differences, of course: dbUnit was created to database test automation. If you are writing JUnit test cases then maybe dbUnit will be first choice.

JUDIE was designed to be a platform independent export/import tool like EXP and IMP is for Oralce. Of course JUDIE has not all the feature like RDBMS tools (EXP/IMP). JUDIE was designed to handle large amounts of data, XML reading is done via SAX parser to minize memory consumption. Data type mapping is handled via properties file, so you don't have to write your own DataTypeFactory.

Of course, both tools can cooperate: you can easily convert JUDIE XML to dbUnit XML and back using XSLT.

the JUDIEclipse4QuantumDb is more like a technology template, but also helpful. You can write your own plugin for other database plugins by copy-paste of this project (but then common classes should go into a common project). But before, the actual design of the plugin should be reviewed and maybe export/import should be integrated into Eclipse Export/Import wizard instead of having own menu items.

-Thomas