Jailer - 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 topologically sorted SQL-DML, hierarchically structured XML and DbUnit datasets.
• Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
• SQL Console with code completion, syntax highlighting and database metadata visualization.