nuodb-migrator load

--target.url=url

No

Target database connection URL in the format:
jdbc:com.nuodb://host:port/database

--target.username=username

No

Target database user name

--target.password=password

No

Target database password

--target.properties=properties

No

Additional connection properties encoded as URL query string, e.g. “property1=value1&property2=value2…​”

--target.schema=schema

No

Database schema name to use. If not provided, objects will be generated in the same schema as the source database schema.

--input.path=input_path

Yes

Path on the file system where the catalog dump file, backup.cat, and data dump file(s) were created. These are created by nuodb-migrator dump.

--input.{csv | xml}.attribute_name=attribute_value

No

Input format attributes. These are specific to the type of input being read.

For CSV, the valid attributes (attribute_name=attribute_value) are:

For XML, the valid attributes (attribute_name=attribute_value) are:

--data={ true | false }

No

Enables or disables data being loaded.
Default is true.

--schema={ true | false }

No

Enables or disables the execution of a DDL sql script file to generate schema objects prior to loading the data.
Default is true.

--data=true --schema=true

Loads both data and metadata into a target NuoDB database using dump files generated by nuodb-migrator dump. This is the default value.

--data=false --schema=true

Generates objects in the target NuoDB database using metadata from dump files generated by nuodb-migrator dump.

--data=true --schema=false

Loads data into a target NuoDB database using dump files generated by nuodb-migrator dump. The objects must already exist in the target NuoDB database.

--commit.strategy={ single | batch | custom}

No

Commit strategy name, either single or batch or fully classified class name of a custom strategy implementing com.nuodb.migrator.jdbc.commit.CommitStrategy. Default is batch.

--commit. commit_strategy_attribute=value

No

Set commit strategy attributes, such as commit.batch.size, which specifies the batch size to load and commit.
Default is 1000, meaning the load will do a commit after every 1000 rows are loaded.

--replace (-r)

No

Writes REPLACE statements rather than INSERT statements for all tables being loaded.

--table.table_name.replace

No

Writes REPLACE statements for the specified table

--table.table_name.insert

No

Writes INSERT statements for the specified table

--time.zone=time_zone

No

Time zone enables data columns to be dumped and reloaded between servers in different time zones

Various schema command line options

No

Various optional schema command options are also supported when the --schema=true command line option is passed to nuodb-migrator dump. For more information, see migration modes and nuodb-migrator schema.

--threads (-t)=threads

No

Number of worker threads. Defaults to the number of available processors. Default command line options values for parallel loader:

--parallelizer (-p)= { table.level | row.level | custom }

No

Parallelization strategy name, either table.level (default), row.level or fully classified class name of a custom parallelizer implementing com.nuodb.migrator.backup.loader.Parallelizer. Table level parallelization activates one worker thread per table at maximum, while row level enables forking with more than one thread, where the number of worker threads is based on the weight of the loaded row set to the size of loaded tables. Notice row level forking may (and typically does) reorder the rows in the target table.

--parallelizer.parallelizer_attribute=value

No

Parallelizer attributes, such as min.rows.per.thread and max.rows.per.thread which are min possible and max allowed number of rows per thread, defaults are 100000 and 0 (unlimited) respectively.

Parallelizer attributes --parallelizer.min.rows.per.thread and --parallelizer.max.rows.per.thread switches are valid with --parallelizer=row.level,
so when --parallelizer=row.level is provided the following defaults are used for parallelizer attributes: