Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

Features

  • Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
  • 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.
  • Improves database performance by removing and archiving obsolete data without violating integrity.
  • API provides programmatic access to export/import functionality. http://jailer.sourceforge.net/api.html
  • A demo database is included with which you can get a first impression without any configuration effort.
  • Documentation: https://wisser.github.io/Jailer/
  • Home: https://github.com/Wisser/Jailer

Project Samples

Project Activity

See All Activity >

License

Apache License V2.0

Follow Jailer

Jailer Web Site

nel_h2
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.
Start Free
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
10
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

User Reviews

  • 非常好用,谢谢作者。
  • Excellent tool, never seen something like this before, really works fine!!
  • Excellent software. I needed something to help me create a subset database and within 15 minutes I had one. Easy to use and understand. Thank you!
  • I love this tool, especially the liquibase export feature. It has allowed me to develop a efficient customer data migration process. I expect I will find other ways to make use of it too. The developer is responsive and very helpful.
  • Brilliant tool, don't know anything like it :-)
Read more reviews >

Additional Project Details

Languages

English

Intended Audience

Developers, Quality Engineers, System Administrators

User Interface

Command-line, Java Swing

Programming Language

Java, PL/SQL

Database Environment

Firebird/InterBase, IBM DB2, JDBC, MySQL, Oracle, PostgreSQL (pgsql), Sybase

Related Categories

PL/SQL Front-Ends, PL/SQL Software Testing Tool, PL/SQL QA Automation Software, Java Front-Ends, Java Software Testing Tool, Java QA Automation Software

Registered

2007-05-31