NuoDB Migrator Properties File

The NuoDB Migrator tool maintains its own log4j properties file, named log4j.properties. Depending on how the NuoDB Migrator tool was installed, this file can be found in one of the following locations:

Migrator Installation Type Location of log4j.properties file
NuoDB Product Installation $NUODB_HOME/tools/migrator/conf/log4j.properties
Github Source Build $NUODB_MIGRATOR_DIR/migration-tools/assembly/target/nuodb-migrator/conf/log4j.properties

The property that sets JDBC connection trace file logging is turned off by default. This option controls logging the DDL SQL statements that execute during the NuoDB Migration tool LOAD command processing. This option is turned off for performance reasons and will have a negative impact on the performance of the LOAD command when turned on. To log these DDL SQL statements, the following line in the properties file should be commented:

# comment the line below to output SQL queries to the log                                                     
log4j.logger.com.nuodb.migrator.jdbc.connection=none

This will log all DDL SQL statements generated to a file named nuodb-migrator.log. An environment variable, NUODB_MIGRATOR_LOGDIR, should be set to define the location of this file. If the environment variable is not set, the file location will default to the system's temporary directory.