Data Migration

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

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

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