Skip to content

Latest commit

 

History

History
58 lines (43 loc) · 3.6 KB

README.md

File metadata and controls

58 lines (43 loc) · 3.6 KB
Raw

Jailer Database Tool

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.

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.

News

  • 2018-04-26 The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions. This allows to reverse-engineer the data model based on existing SQL queries.
  • 2018-03-06 SQL Console with code completion, syntax highlighting and database metadata visualization.
  • 2017-05-10 New API provides programmatic access to the data export and import functionality. http://jailer.sourceforge.net/api.html
  • 2017-03-30 Improved filter management. Support for import-filters and literal-filters.
  • 2017-01-27 Referential cycles can now be exported by deferring the insert of nullable foreign keys.
  • 2016-21-10 Filter Templates allows you to define rules for assigning filters to columns.Filters on primary key columns will automatically be propagated to the corresponding foreign key columns.
  • 2015-12-04 Support for oracle's ROWID pseudo-column.
  • 2016-09-08 New "Export To" mode allows to export rows directly into a different schema in the same database.
  • 2015-12-04 Support for oracle's ROWID pseudo-column.
  • 2015-10-23 Release 5.0 introduces the ability to collect rows in a separate embedded database. This allows it to export data from read-only databases.
  • 2011-07-20 Implemented the "Subset by Example" feature: Use the Data Browser to collect all the rows to be extracted and let Jailer create a model for that subset.
  • 2010-04-15 A Data Browser has been introduced. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
  • 2008-12-23 Jailer now supports the DbUnit flat XML dataset file format, thus allowing the users of the famous JUnit extension DbUnit to use the extracted data for unit testing.
  • 2007-12-05 Version 2.0 comes with new graphical user interface.
  • 2007-06-05 Tutorial for Jailer now available.

Installation

Use the installer "Jailer-Install-n.n.n.exe" or unzip the file "jailer_n.n.n.zip". See also http://jailer.sourceforge.net/faq.html#multiuser

  • Database Subsetter

    • On windows platform execute "Jailer.exe". You can also start "jailerGUI.bat".
    • On Unix/Linux platform execute the script "jailerGUI.sh" or use "java -jar jailer.jar"

  • Data Browser

    • On windows platform execute "jailerDataBrowser.exe", or "jailerDataBrowser.bat"
    • On Unix/Linux platform execute the script "jailerDataBrowser.sh"

Contact