Over a million developers have joined DZone.

Jailer: Database Subsetting and Sampling Tool.


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.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}