Data Migration

After performing the schema migration, complete the following steps to migrate data:

  1. Use EDB Migration Toolkit to migrate the data. For detailed information about using Migration Toolkit, see the EDB Postgres Migration Guide.
  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:

    runMTK.sh –dataOnly –targetSchema hr –truncLoad HR

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

    Please Note: The tables are truncated before attempting the data load.