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
Simply solve complex auth. Easy for devs to set up. Easy for non-devs to use. Icon
Simply solve complex auth. Easy for devs to set up. Easy for non-devs to use.

Transform user access with Frontegg CIAM: login box, SSO, MFA, multi-tenancy, and 99.99% uptime.

Custom auth drains 25% of dev time and risks 62% more breaches, stalling enterprise deals. Frontegg platform delivers a simple login box, seamless authentication (SSO, MFA, passwordless), robust multi-tenancy, and a customizable Admin Portal. Integrate fast with the React SDK, meet compliance needs, and focus on innovation.
Start for 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