Migrating Oracle 9i/10g/11g to PostgreSQL database

First of all, if you have not installed ESF Database Migration Toolkit, get it nowdownload. You can using this toolkit to migrating Oracle 9i/10g/11g to PostgreSQL database in 3 easy steps.

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

  • Put the Oracle server name, listenning port.
  • Put the Oracle usename(default is "system") and its password.
  • Select the logon method(SID, Service_Name or TNS).
  • Put the source Oracle SID or Service_Name in "Database" box or let it empty if you choosing TNS method.
  • Put the Oracle schema name or let it empty(default is same as username).

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

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

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

  • Select the tables which will be migrated.
  • Click "..." to re-map table structure if you need.

4). In "Execution" Dialog

  • click "Submit" to starting migration.

It is so easy to migrate Oracle to PostgreSQL database, isn't it?.

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