Jailer

From HandWiki - Reading time: 1 min

Jailer is a tool for database subsetting and relational data browsing [1]. 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 release2019
Stable release
10.5 / June 2021
Written inJava
Operating systemCross-platform, Windows, MacOS, Software:Linux
Available inEnglish
LicenseOpen source (GPLv3 or later, GPL and similar)
Websitegithub.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.


References




Licensed under CC BY-SA 3.0 | Source: https://handwiki.org/wiki/Software:Jailer
8 views | Status: cached on October 03 2024 08:34:14
↧ Download this article as ZWI file
Encyclosphere.org EncycloReader is supported by the EncyclosphereKSF