Jailer is a powerful and smart data extraction tool that enables you to: Extract small consistent (referentially intact) row-sets from your productive database and import the data into your development and test environment. Remove and archive obsolete data from your productive database.
Extracts consistent, referentially intact row-sets from your R-DB (DB2, Firebird, and Derby). Also Removes and archives obsolete data w/o violating integrity. Highly configurable, generates topologically sorted SQL-DML.