Migrating from Oracle to PostgreSQL

This document describing how to using ESF Database Migration Toolkit to migrating from Oracle to PostgreSQL in 3 easy steps.

Requirements:

Windows XP or higher.
ESF Database Migration Toolkit download.
Oracle 9i or higher.
PostgreSQL 7.x or higher.

Introduction:

1). In "Choose a Data Source" dialog, choose "Oracle Database";

  • Input the server name(e.g.: localhost), listenning port(e.g.: 1521).
  • Input the usename(default is "system") and its password.
  • Select the logon method(SID, Service_Name or TNS).
  • Input the source Oracle SID or Service_Name in "Database" box or let it empty if you choosing TNS method.
  • Input the schema name or let it empty(default is same as username, you can press "Refresh" button to list all schemas).
    Oracle

2). In "Choose a Destination" dialog, choose "PostgreSQL Database";

  • Input the server name, listenning port.
  • Input the username(default is "postgres") and its password.
  • Select the target database character set(default is "UTF8"), it is very important if the data containts Non-Ascii characters e.g. German, French, Japanese.
  • Input the target database name, if you forget the database name, press "Refresh" to list automation.
  • Input/select the target PostgreSQL schema name(default is "public") .
    PostgreSQL

3). In "Select source Tables(s) & View(s)" dialog

  • Select the tables which will be migrated.
    Select Tables&Views

  • Click "..." to setting the table options or re-map the table structure.
    Transform

4). In "Execution" Dialog

  • Click "Submit" to starting migration, this tookit will help you migrate data from Oracle to Postgresql without intervention.
    Execute

5). Finished

If you have any questions or suggestions, please contact us. Thank you for your time!

Download Now! »