Steps for Migrating Data to NuoDB

The NuoDB Migrator allows you migrate from a source (NuoDB or 3rd party) database to a target NuoDB database. This documentation includes specific JDBC driver specifications and examples for each source database that the NuoDB Migration tool supports. Regardless of the source 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 3rd party) database

NuoDB Migrator communicates with both NuoDB and 3rd party databases 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:

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

See the following topics:

Dumping a Source Database to be Migrated

Loading Dumped Files into NuoDB Target Database

Generating DDL SQL Statement Scripts for Migrated Data