Installation

Table of Contents

Download

Download current version from download page and extract the package.

Configuration

Copy template configuration files from folder templates/conf to folder conf.

Cut T_ from every file for default filenames:

template filenamedefault filename
T_database.confdatabase.conf
T_flyway.confflyway.conf
T_log4j.propertieslog4j.properties

Update the configuration to fit your environment.

database.conf (template: T_database.conf)

JDBC url

JDBC url for connection to the database. Replace <host> and <port>.

database.url=jdbc:sqlserver://<host>:<port>

If you want to connect with integrated authentication, please follow the instructions in the Microsoft documentations.
Using Kerberos integrated authentication to connect to SQL Server

User and password

Uncomment and set user name for sql server authentication.

# database.user=

Uncomment and set password for sql server authentication.

# database.password=

Database

Name of the database for which the data is to be collected.

database.database=

Output database

All collected data is stored in this database.

database.outputdatabase=

flyway.conf (template: T_flyway.conf)

Only the following parameters may be adjusted. The others must remain unchanged.
For a deeper insight, please use the Flyway documentation.

JDBC url

JDBC url for connection to the database.

flyway.url=

Use the same as you do with database.url, but add the following.

Replace <outputdatabase> with the one you used for database.outputdatabase.

;databaseName=<outputdatabase>

User and password

User and password correspond to the configuration of database.user and database.password.

# flyway.user=
# flyway.password=

log4j.properties (template: T_log4j.properties)

By default all logging goes to stdout. Change log4j properties for any other supported destination.

See https://logging.apache.org/log4j/2.x/manual/index.html for details.

Installation

If the standard filenames are used, the installation can be performed as follows:

java -jar _rpiNET_dbtools-<version>.jar -c

Please note that the parameter -c automatically generates the output database. This can be omitted if an existing database is to be used.

See command-line parameters for all command line options.