Repository Github

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 everey file for default filenames:

template filenamedefault filename
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>

Add this if you want to connect with windows integrated authentication.

;IntegratedSecurity=true

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.

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.

Add -2016 if installing on SQL Server versions prior to 2016.

See command-line parameters for all command line options.