Jailer is a tool for database subsetting, schema browsing, and rendering. It exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. It is DBMS agnostic (by using JDBC), platform independent, and generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.

Features:

• 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.

System Requirements:

• Java Runtime Environment (JRE) 6 or above. Get It Here.
• JDBC-driver for your R-DBMS

What´s New in version 4.0.3:

• Added missing ';' at end of lines in generated delete script on DB2 on Z/OS