From the home page:
Home page: http://jailer.sourceforge.netJailer 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.
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 %*
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.