Jailer
Jailer is a database subsetting and sampling tool. It is a tool for data exporting, 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.
| Tags | Database Front-Ends Software Development Testing Utilities Archiving Test Data Database Subsetting |
|---|---|
| Licenses | Apache 2.0 |
| Operating Systems | OS Independent |
| Implementation | Java |
| Translations | English |
Recent releases
- 13 Jul 2009 14:40
Changes: A progress indicator was added for the SQL import tool. Minor GUI improvements were made.
- 07 Jul 2009 12:38
Changes: Support for multi-row inserts in Oracle has been added. A new feature for parametrizing filters, XML templates, restriction conditions, and subject conditions have been introduced, as well as GUI support for multi-line conditions and filters. The "Query Builder" allows the user to build SQL queries based on the data model.
- 25 Jun 2009 06:50
Changes: Extensive internal refactoring, GUI improvements, and a fix for a problem where $IS_SUBJECT/$DISTANCE expressions were not always evaluated correctly.
- 17 Jun 2009 16:49
Changes: The "connection" dialog has been redesigned. A bug concerning multi-line CLOB content has been fixed.
- 03 Jun 2009 12:52
Changes: Support has been added for MS SQL's identity column type and BIT type. The length of lines in SQL export files has been limited to 2400 bytes so that Oracle's utility SQLPLUS can be used to import the data.
