Jailer

Jailer is a tool for database subsetting, schema, and data browsing. It exports consistent, referentially intact row-sets from relational databases.

The tool 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.