About NuoDB Migrator Commands

The NuoDB Migrator supports three commands for migrating database schema objects and data from a source (NuoDB or 3rd party) database to a target NuoDB database. The NuoDB Migrator tool commands include:

Command Description

Command	Description
schema	The `schema` command generates DDL SQL statement scripts to generate objects defined in the source NuoDB or 3rd party database. Optionally, the `schema` command executes the generated DDL SQL object create statements directly in the target NuoDB database, or writes them to a specified file. There are also command line options to override certain default behaviors, such as how the NuoDB Migrator tool maps source database data types to NuoDB target database data types.
dump	The `dump` command generates a csv or xml file formatted data dump for each table found and also creates a schema meta data information file for a source NuoDB or 3rd party database. There are command line options that are available for specifying this data, such as filters for selecting the data to be dumped, format for the data dump files, etc.
load	The `load` command reads the data files generated by the NuoDB Migrator tool `dump` command and loads the data into a target NuoDB database. There are command line options that are available to override certain default behaviors, such as how the NuoDB Migrator tool maps source database data types to NuoDB target database data types.

schema

The schema command generates DDL SQL statement scripts to generate objects defined in the source NuoDB or 3rd party database. Optionally, the schema command executes the generated DDL SQL object create statements directly in the target NuoDB database, or writes them to a specified file. There are also command line options to override certain default behaviors, such as how the NuoDB Migrator tool maps source database data types to NuoDB target database data types.

dump

The dump command generates a csv or xml file formatted data dump for each table found and also creates a schema meta data information file for a source NuoDB or 3rd party database. There are command line options that are available for specifying this data, such as filters for selecting the data to be dumped, format for the data dump files, etc.

load

The load command reads the data files generated by the NuoDB Migrator tool dump command and loads the data into a target NuoDB database. There are command line options that are available to override certain default behaviors, such as how the NuoDB Migrator tool maps source database data types to NuoDB target database data types.

To get available command line options for any one of these NuoDB Migrator tool commands, run the following:

nuodb-migrator --help [schema | dump | load]