Table of Contents Previous Next


6 Executing Migration Toolkit : 6.2 Migrating from a Non-Oracle Source Database

$ ./runMTK.sh –sourcedbtype db_type –targetdbtype target_type [options, …] schema_name;
-sourcedbtype source_type
source_type specifies the server type of the source database. source_type is case-insensitive. By default, source_type is oracle. source_type may be one of the following values:
oracle (the default value)
postgres or postgresql
target_type specifies the server type of the target database. target_type is case-insensitive. By default, target_type is enterprisedb. target_type may be one of the following values:
postgres or postgresql
schema_name is the name of the schema within the source database (specified in the toolkit.properties file) that you wish to migrate. You must include at least one schema_name.
The following example migrates a schema (table definitions and table content) named HR from a MySQL database on a Linux system to an Advanced Server host. Note that the command includes the ‑sourcedbtype and targetdbtype options:
> .\runMTK.bat -sourcedbtype mysql -targetdbtype enterprisedb HR

6 Executing Migration Toolkit : 6.2 Migrating from a Non-Oracle Source Database

Table of Contents Previous Next