NuoDB Migrator Properties File

The NuoDB Migrator tool maintains its own log4j properties file, named 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 file
NuoDB Product Installation $NUODB_HOME/tools/migrator/conf/
Github Source Build $NUODB_MIGRATOR_DIR/migration-tools/assembly/target/nuodb-migrator/conf/

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                                            

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.