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.

NuoDB Migrator is part of the Client-only package. To execute NuoDB Migrator after it has been installed, ensure that the location of the NuoDB JDBC driver jar (nuodbjdbc.jar) has been added to your CLASSPATH. For example:

export CLASSPATH=nuodbjdbc.jar:${CLASSPATH} bin/nuodb-migrator

For more information on the Client-only package, see Product Distribution Package Files in Physical or VMware Environments.

Released binary versions of NuoDB Migrator can be download from GitHub.

Sequences

If there are sequences, NuoDB 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.

Databases Supported by NuoDB Migrator

NuoDB Migrator supports migration of data from the following databases:

Database

Version

MySQL 5.5
PostgreSQL 9.2
Oracle 11.2
SQL Server 11.0
DB2 10 (DSN10015)

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

See the following topics: