Open topic with navigation
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:
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 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 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]