NuoDB Migrator

NuoDB Migrator is a command line Java program that helps database administrators migrate schemas and existing data to a NuoDB database. It interfaces with a source database over a JDBC compliant driver and is designed to support all major RDBMSs. It also interfaces with the NuoDB target database using the NuoDB JDBC driver. You can also use NuoDB Migrator as a NuoDB backup/restore utility when both the source and target databases are NuoDB databases.

The NuoDB Migrator tool comes bundled with the NuoDB product download. The executable script is in the NUODB_HOME/tools/migrator/bin directory.

Note: On Windows, you must ensure that either the JAVA_HOME environment variable is set or that Java is reachable by means of the PATH environment variable. This is required to run the nuodb-migrator.bat file, which runs the Java jvm. The nuodb-migrator.bat file first checks whether the JAVA_HOME environment variable is set. If it is, it is used as the Java executable location. If JAVA_HOME is not set, the script tries to use the Java version currently installed in the system PATH.

Sequences

If there are sequences, the migrator will migrate them with the correct starting value if the dump/load method is used. This dumps the data and the DDL to create the sequence in 1 step, which makes sure the sequence will start with a value that is greater than the data.

If not migrated in 1 step (i.e. the schema command is used to generate the DDL and then the dump/load commands are used to dump and load the data) then data can be inserted into the source database after the DDL is generated which can cause the sequence start with value to be lower than existing data when it is dumped/loaded into the target database. This will cause an error when the 1st row after the migration is inserted into the table using a generated sequence value that may already exist.

Note: For oracle, since sequences and tables are not associated, the migrator will just migrate the sequence start with same as what it is in oracle.

See the following topics:

Downloading NuoDB Migrator Source Code

NuoDB Migrator Properties File

About NuoDB Migrator Commands

How NuoDB Migrator Maps Data Types

Steps for Migrating Data to NuoDB

Examples of Migrating Data to NuoDB

Using NuoDB Migrator to Copy NuoDB Databases

NuoDB Migrator Schema Command

NuoDB Migrator Dump Command

NuoDB Migrator Load Command