Software:Jailer

Jailer is a tool for database subsetting and relational data browsing . The Subsetter exports consistent, referentially intact row-sets from relational databases, generates topologically sorted SQL-DML, DbUnit datasets and hierarchically structured XML. The Data Browser allows bidirectional navigation through the database by following foreign-key-based or user-defined relationships.

Jailer

Initial release	2019
Stable release	10.5 / June 2021
Written in	Java
Operating system	Cross-platform, Windows, MacOS, Software:Linux
Available in	English
License	Open source (GPLv3 or later, GPL and similar)
Website	github.com/Wisser/Jailer

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.