You are here: Reference Information > Command Line Tools > NuoDB Migrator > About NuoDB Migrator Commands

About NuoDB Migrator Commands

The NuoDB Migrator supports three(3) 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
dump The dump command generates a data dump file and meta data information 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 creates objects and loads data into a target NuoDB database. This load command uses files generated by the NuoDB Migrator tool dump command. 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. This schema command executes the DDL SQL statement script in the target NuoDB database. 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.

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

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