Java tool to export data from database in files

Supported file formats and datatypes:

• CSV (Comma-Separated-Values, .csv)
• JSON (.json)
• XML (.xml)
• vCards (.vcf)
• Excel old (<= 2003) (.xls)
• Excel new (2007+) (.xlsx)
• OpenDocumentSheet (.ods)
• KeePass (.kdbx)

Supported file compressions:

• Uncompressed
• Zip (.zip, optionally with password using aes or zipcrypto)
• Tar (.tar)
• TarGz (.tar.gz)
• GZip (.gz)

Supported database vendors:

• MySQL
• MariaDB
• Oracle (use SID, servicename or TNS description)
• PostgreSQL
• Firebird
• Sqlite
• Derby
• Hsql
• Cassandra

Commandline usage

java -jar DbExport.jar [optional parameters] dbtype hostname[:port] dbname username -export exportdata -output outputpath [password]

Simple usage: java -jar DbExport.jar dbtype hostname username dbname 'statement or list of tablepatterns' outputpath

Mandatory parameters for database export

dbtype: mysql | mariadb | oracle | postgresql | firebird | sqlite | derby | hsql | cassandra
hostname: With optional port (Not needed for sqlite, hsql and derby)
dbname: Dbname or filepath for sqlite database or derby db
username: Username (Not needed for sqlite and derby)
password: Is asked interactivly, if not given as parameter (Not needed for sqlite, hsql or derby)

-export exportdata: SQL statement (Encapsulate by ', escape sequence is '')
					or comma-separated list of tablenames with wildcards *? and !(= not, use as tablename prefix)
					or text file path (See optional parameter '-file')
-output outputpath: File for single statement
					or directory for tablepatterns
					or 'console' for output to terminal
					may contain datetime placeholders ([YYYY], [MM], [DD], [hh], [mm], [ss])

Optional parameters for database export

-x exportformat: Data export format, default format is CSV
	exportformat: CSV | JSON | XML | SQL | VCF | KDBX
	(Don't forget to beautify json for human readable data)
-n 'NULL': Set a string for null values (Only for csv and xml, default is '')
-file: Read statement or tablepattern from text file
-l: Log export information in .log files
-v: Progress and e.t.a. output in terminal
-z: Output as zipfile (Not for console output, same as "-compress zip")
-compress compresstype: Compress output (Not for console output)
	compresstype: ZIP | TARGZ | TGZ | GZ
-zippassword '<zippassword>' (using AES-256 by default, not supported by Windows)
-kdbxpassword '<kdbxpassword>' (for KDBX datatype)
-useZipCrypto (use ZipCrypto algorithm, which is weak but is supported by Windows)
-e: Output encoding (Default UTF-8)
-s: Separator character, default ';', encapsulate by '
-q: String quote character, default '"', encapsulate by '
-qe: String quote escape character, default '"', encapsulate by '
-i: Indentation string for JSON and XML (TAB, BLANK, DOUBLEBLANK), default TAB or '\t', encapsulate by '
-a: always quote value
-f: Date and datetime format locale, default is systems locale, use 'de', 'en', etc. (e.g. for weekdays in format, 'EEE')
-dateFormat: overrides language format, use Java format characters (YMdhmsS) 
-dateTimeFormat: overrides language format, use Java format characters (YMdhmsS)
-decimalSeparator: overrides language format, use '.' or ','
-blobfiles: Create a file (.blob or .blob.zip) for each blob instead of base64 encoding
-clobfiles: Create a file (.clob or .clob.zip) for each clob instead of data in csv file
-beautify: Beautify csv output to make column values equal length (Takes extra time)
	or beautify json output to make it human readable with linebreak and indention
-noheaders: Don't export csv header line
-structure: Export the tables structure and column types
-dbtz '<databaseTimeZone>': Use a DatabaseTimeZone (Default is systems default timezone, e.g. Europe/Berlin or Europe/Dublin)
-edtz '<exportDataTimeZone>': Use a ExportDataTimeZone (Default is systems default timezone, e.g. Europe/Berlin or Europe/Dublin)
-secure: Use TLS/SSL for secure communication with database
-truststore '<truststorefilepath>': Filepath to TrustStore in JKS format for encrypted database connections of some database vendors
-truststorepassword '<password>': Optional password for TrustStore

Global standalone parameters

help: Show this help manual
gui: Open a GUI (Other parameters may also be preconfigured)
menu: Open a Console menu (Other parameters may also be preconfigured)
version: Show current local version of this tool
update: Check for online update and ask, whether an available update shell be installed;

Connection test:

Usage: java -jar DbImport.jar connectiontest dbtype hostname[:port] dbname username [-iter n] [-sleep n] [-check checksql] [password]

-iter n: Iterations to execute. Default = 1, 0 = unlimited
-sleep n: Sleep for n seconds after each check. Default = 1
-check checksql: SQL statement to check or the keyword "vendor" for the vendors default check statement
password: Is asked interactivly, if not given as parameter (Not needed for sqlite, hsql or derby)

Create TrustStore:

Usage: java -jar DbImport.jar createtruststore hostname:port truststorefilePath [truststorepassword]

truststorefilePath: Filepath to create the TrustStore file in 
truststorepassword: Optional password for the created TrustStore (JKS, JavaKeyStore)