Jailer

Submit portable freeware that you find here. It helps if you include information like description, extraction instruction, Unicode support, whether it writes to the registry, and so on.
Post Reply
Message
Author
thepiney
Posts: 161
Joined: Wed Aug 31, 2011 11:57 am

Jailer

#1 Post by thepiney »

A Java based database program for "database subsetting, schema and data browsing".

From the home page:
Jailer is a tool for database subsetting, schema and data browsing. It exports consistent, referentially intact row-sets from relational databases. It removes obsolete data without violating integrity. It is DBMS agnostic (by using JDBC), platform independent, and generates DbUnit datasets, hierarchically structured XML, and topologically sorted SQL-DML.
Home page: http://jailer.sourceforge.net

SourceForge Project page: https://sourceforge.net/projects/jailer

GitHub page: https://github.com/Wisser/Jailer

License: Apache License V2.0

Extraction: Just extract the zip file and start using the .exe file or .bat files.

If you don't have Java installed but use jPortable just edit the batches (.bat) files to add the path to jPortable as follows --- Works for me when extracted into PortableApps directory.

jailerDataBrowser.bat --> I renamed to jailerDataBrowser_p.bat

Code: Select all

@echo off
set LIB=lib

rem JDBC-driver
rem set CP=%CP%;<jdbc-driver>.jar

rem configuration files in the config directory
set CP=%CP%;config

rem the libraries
set CP=%CP%;%LIB%\junit.jar
set CP=%CP%;%LIB%\commons-logging.jar
set CP=%CP%;%LIB%\log4j.jar
set CP=%CP%;%LIB%\args4j.jar
set CP=%CP%;%LIB%\spring.jar
set CP=%CP%;%LIB%\prefuse.jar
set CP=%CP%;%LIB%\sdoc-0.5.0-beta.jar
set CP=%CP%;%LIB%\activation-1.0.2.jar
set CP=%CP%;%LIB%\jaxb-core-2.3.0-b170127.1453.jar
set CP=%CP%;%LIB%\jaxb-impl-2.3.0-b170127.1453.jar
set CP=%CP%;%LIB%\jaxb-api-2.3.0-b170201.1204.jar
set CP=%CP%;%LIB%\jsqlparser-3.2.jar
set CP=%CP%;%LIB%\tablefilter-swing-5.3.1.jar
set CP=%CP%;jailer.jar

start ..\CommonFiles\Java64\bin\javaw -Xmx1024M -Djava.util.Arrays.useLegacyMergeSort=true -cp %CP% net.sf.jailer.ui.databrowser.DataBrowser %*
I only found Windows based hits in the registry and config files were stored in the program directory.

Export --> I opened the batch file for "JailerDataBrowser" and opened an included Demo then one of the Tables. When I selected to export I get these drop down options in the "Target DBMS" --> Oracle, MS SQL Server, MySQL, MariaDB, DB2 LUW, DB2 z/OS, Informix, PostgreSQL, Redshift, Cloudscape, Firebird, Derby, Sybase, SQLite, HSQLDB and H2.

Image

Post Reply