| Ⅰ | This article along with all titles and tags are the original content of AppNee. All rights reserved. To repost or reproduce, you must add an explicit footnote along with the URL to this article! |
| Ⅱ | Any manual or automated whole-website collecting/crawling behaviors are strictly prohibited. |
| Ⅲ | Any resources shared on AppNee are limited to personal study and research only, any form of commercial behaviors are strictly prohibited. Otherwise, you may receive a variety of copyright complaints and have to deal with them by yourself. |
| Ⅳ | Before using (especially downloading) any resources shared by AppNee, please first go to read our F.A.Q. page more or less. Otherwise, please bear all the consequences by yourself. |
| This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. |
Jailer is a powerful, easy-to-use, reliable and intelligent data extraction tool that can help developers easily export continuous and related row data directly from relational databases, and then directly use it in your own development/test environment. With help of Jailer, you can delete a specific row of data without compromising the integrity of other data, and improve the operating efficiency of database.
Jailer is a platform that runs independently, so it doesn’t matter if you don’t have the corresponding application required to run the database file. It can directly generate DbUnit data sets, topologically sorted SQL-DML and hierarchically structured XML documents, and supports database applications such as IBM Db2, Firebird, and Apache Derby. In addition to data extraction, you can also edit and execute SQL statements directly on the data browser interface, and edit the compiled results.
Jailer can connect to multiple databases at the same time, also allows users to create multiple database connections, supports PostgreSQL, Oracle, MySQL, MariaDB, Microsoft SQL Server, IBM Db2, SQLite and other commonly used database applications. After the connection is successful, you can query data, analyze the database, create extraction models, and analyze SQL scripts, so as to filter the data you need and export it to the computer for use. In addition, Jailer also provides a case content, where you can learn how to export data.
// Key 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 topologically sorted SQL-DML, hierarchically structured XML and DbUnit datasets.
- Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
- SQL Console with code completion, syntax highlighting and database metadata visualization.
- A demo database is included with which you can get a first impression without any configuration effort.
// Official Demo Video //
// Supported Databases //
Thanks to the JDBC technology used, any DMBS is in principle supported. For best results, specific additional support features are useful, however. These are available for:
- PostgreSQL
- Oracle
- MySQL
- MariaDB
- Microsoft SQL Server
- IBM Db2
- SQLite
- Sybase
- Amazon Redshift
- Firebird
- Informix Dynamic Server
- H2
- HSQL (HyperSQL)
- Derby
- Interbase
- ….
// System Requirements //
- Java Runtime Environment
// Related Links //
// Download URLs //
| License | Version | Download | Size |
| Freeware | Latest |  (mir) |
n/a |
(Homepage 1 | Homepage 2 | SourceForge)
| If some download link is missing, and you do need it, just please send an email (along with post link and missing link) to remind us to reupload the missing file for you. And, give us some time to respond. | |
| If there is a password for an archive, it should be "appnee.com". | |
| Most of the reserved downloads (including the 32-bit version) can be requested to reupload via email. |