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