Jailer 3.1 (Freeware)

Jailer is a tool for database subsetting and sampling, schema browsing, and rendering. Jailer exports consistent, referentially intact row-sets from relational databases.Jailer will allow you to easily remove obsolete data without violating integrity. Jailer is DBMS agnostic, platform independent, and generates DbUnit datasets, topologically sorted SQL-DML, and hierarchically structured XML
key features of "Jailer":

· 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.
· Mass data export to XML and SQL.
· Generates hierarchically structured XML and topologically sorted SQL-DML.
· Open Source. Entirely written in Java. Platform independent. DBMS agnostic.
Requirements:

· Java JRE 5 or above
· R-DBMS with JDBC-driver
What's New in This Release: [ read full changelog ]

· A new feature for parametrizing filters, XML-templates, restriction conditions and subject conditions has been introduced.
· GUI support for multi-line conditions and filters.
· The "Query Builder" allows the user to build SQL queries based on the data model.
· A bug concerning XML export on windows platform has been fixed.
· Minor bug fixes.