Command line

DB Toolbox can be invoked from command line:

Invokation

  • Windows DOS command line:
    bin/dbtool.bat etc/config.properties
  • Unix Shell command line:
    bin/dbtool.sh config.properties

Configuration

Connection configuration

connection.factory Connection type, either driver for JDBC driver or jndi for JNDI registered datasource.
Default: driver
connection.url JDBC database URL or JNDI registry URL
connection.username Login
connection.password Password
connection.driver.class.name JDBC Driver class name
Applies only: jdbc
connection.driver.class.path Class path to load the JDBC Driver
Applies only: jdbc

Extractor configuration

extractor.type Database product type, either hsqldb, mysql,postgres, derby or oracle
Default: Automatically detected database product type and if unknown use generic one.
extractor.catalogName Name of the catalog to extract
Applies only: mysql

Validator configuration

validator.file Validator configuration file location
validator.format Validator configuration file format, either xml or properties
Default: Automatically detected from extension

Generator configuration

generator.name Generator name, either html for HTML website, text for plain text document or xml for XML document.
Default: html
generator.output.folder Output folder
Applies only: html or xml
generator.output.file Output file
Applies only: text