Migrating Data to NuoDB

nuodb-migrator allows you migrate from a source (NuoDB or third-party) database to a target NuoDB database. This documentation includes specific JDBC driver specifications and examples for each source database that nuodb-migrator supports. Regardless of the type of database that is being migrated, the steps for migrating a source database to a target NuoDB database are the same.

Install the JDBC Driver for the source (NuoDB or third-party) database

nuodb-migrator communicates with the source database via JDBC. A JDBC driver is required for both the source and target database connections. You will find information about each supported JDBC driver, its class name and its standard JDBC URL format on each of the source database example pages:

Example of Migrating From IBM DB2

Example of Migrating From MSSQL

Example of Migrating From MySQL

Example of Migrating From Oracle

Example of Migrating From PostgreSQL

Using nuodb-migrator to Copy NuoDB Databases

Installing the JDBC driver jar file can be done by one of two options:

  • Define the JDBC driver jar file on the Java CLASSPATH

  • Copy the JDBC driver jar file to the nuodb-migrator tool jar directory

Depending on how the nuodb-migrator tool was installed, the JDBC driver should be copied to one of the following locations:

Migrator Installation Type Jar File Destination

NuoDB Product Installation

NUODB_HOME/tools/migrator/jar

GitHub Source Build

NUODB_MIGRATOR_DIR/migration-tools/assembly/target/nuodb-migrator/jar