Jailer: Database Subsetting and Sampling Tool.
Join the DZone community and get the full member experience.Join For Free
If you use an enterprise application, you probably maintain full-size copies of the production database to meet development and testing requirements. Numerous copies are unnecessarily full-size as development and testing teams may only require relatively small samples of data to meet their objectives.
Jailer is a software development tool that helps to provide developers with test data.
Jailer exports consistent, referentially intact row-sets from relational databases (exports data from production database and imports it into development database). It's also able to remove obsolete data without violating integrity.
It generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML.
Opinions expressed by DZone contributors are their own.