Database Subsetting and Browsing Tool
Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML
- Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
- Improves database performance by removing and archiving obsolete data without violating integrity.
- Generates hierarchically structured XML, topologically sorted SQL-DML and DbUnit datasets.
- Open Source. Entirely written in Java. Platform independent. DBMS agnostic.
Amazingly slick tool that is immensely useful (after some time spent on getting to know it properly)!
This project is on the list of "most used" tools in my workshop. It allows me to visualise my database, explore associations and make sure that the structure is not ot tangled. It's also fun to work with it, as it's good looking, responsive and elegant. I cannot do anything else but recommend it to everyone, that needs to "see his composition" :)
Perfect for database extraction with reference integrity.
Jailer is an exceptional tool, I've used it again and again to test on a subset of a very large databese. It's very simple and very easy to use yet powerful, and so useful, provided you have designed your db with referential integrity constraints. Every time I use it I love it more!