Performing a data migration v4

After performing the schema migration, migrate the data.

  1. Use Migration Toolkit to migrate the data. For detailed information about using Migration Toolkit, see Migration Toolkit.

  2. Configure the Migration Toolkit toolkit.properties file, ensuring that connection information for the source and target databases is available in the property file:

SRC_DB_URL = jdbc: oracle:thin:@localhost:1521:ORCL
SRC_DB_USER = user_name
SRC_DB_PASSWORD = password
TARGET_DB_URL= jdbc:edb://localhost:5444/migration
TARGET_DB_USER = enterprisedb
TARGET_DB-PASSWORD = password

For more information, see Building the toolkit.properties File.

  1. Invoke Migration Toolkit in –dataOnly mode. Include the –truncLoad keyword to resolve foreign key dependencies across tables.

    For example, the following command migrates data to a schema named hr:

    runMTK.sh –dataOnly –targetSchema hr –truncLoad HR

    The command migrates the specified source_schema to target_schema. The data is loaded into the locally installed EDB Postgres Advanced Server instance with a database superuser named enterprisedb and the password of password.

    Note

    The tables are truncated before attempting the data load.