Jailer可以从">关系数据库中直接导出连续、相关的行数据,直接在你自己的开发/测试环境中使用。通过Jailer,你可以在不损害其它数据完整性的情况下,删除某一特定数据行,提高数据库的运行效率。
Jailer是一个独立运行的平台,所以你即使没有运行该数据库文件所需要的对应应用程序也不要紧,它可以直接生成DbUnit数据集,以拓扑方式排序的SQL-DML以及阶级性结构的XML文档。
Jailer 是一个功能强大的智能型数据提取工具,可以支持DB2、Firebird、Derby等应用。它使用方便,运行的时间需要Java JRE 5的支持。
该版本修复了 3.5 版本一个严重的功能问题,在 3.5 版本中无法修改主题表的问题已被修复。
Jailer is a tool for database subsetting and sampling, 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.
Features:
·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 hierarchically structured XML, topologically sorted SQL-DML and DbUnit datasets.
·Open Source. Entirely written in Java. Platformindependent. DBMS agnostic.
下载地址:http://sourceforge.net/projects/jailer/files/