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…
Permalink
Failed to load latest commit information.
admin 7.8.1 Apr 27, 2018
config moved spring logger May 5, 2017
datamodel SQL console Oct 10, 2017
docs new screenshots May 30, 2018
example added examples Dec 15, 2008
extractionmodel Introduction of the "expansion limit" feature for improved navigation Jul 26, 2017
layout preparing release 3.7.9 Nov 17, 2011
lib update Aug 31, 2018
render fixed rendering bug Jun 27, 2007
src prepared UI for standard l&f Oct 19, 2018
template fixed rendering bug Jun 27, 2007
.classpath added JAXB libs Aug 10, 2018
.project separated ui from subsetter Apr 21, 2017
Jailer.exe added tablefilter-swing-5.3.1.jar Nov 2, 2017
Jailer.html new logo Jun 23, 2009
JailerDataBrowser.exe added tablefilter-swing-5.3.1.jar Nov 2, 2017
README.md Doc updates Apr 25, 2018
build.xml added tablefilter-swing-5.3.1.jar Nov 2, 2017
dbeauty.bat Added "Columns", "Text" and "Meta" views to SQLConsole Feb 13, 2018
dbeauty.exe Added "Columns", "Text" and "Meta" views to SQLConsole Feb 13, 2018
dbeauty.sh Added "Columns", "Text" and "Meta" views to SQLConsole Feb 13, 2018
demo-sakila.h2.db reseted demo database Apr 5, 2018
demo-scott-subset.h2.db new May 4, 2017
demo-scott.h2.db inserted some rows into BONUS Jun 14, 2018
driverlist.csv Use console connection for "Reload" too. Oct 16, 2018
jailer.bat new filter type allows to exclude columns from export Aug 3, 2017
jailer.sh new filter type allows to exclude columns from export Aug 3, 2017
jailerDataBrowser.bat added tablefilter-swing-5.3.1.jar Nov 2, 2017
jailerDataBrowser.sh added tablefilter-swing-5.3.1.jar Nov 2, 2017
jailerGUI.bat added tablefilter-swing-5.3.1.jar Nov 2, 2017
jailerGUI.sh added tablefilter-swing-5.3.1.jar Nov 2, 2017
license-prefuse.txt renamed Apr 28, 2008
license.txt initial import Jun 5, 2007
releasenotes.txt release notes update Oct 18, 2018

README.md

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-.exe" or unzip the file "jailer_.zip".