PostgreSQL to Oracle Tutorial

On this wizard screen connection settings for PostgreSQL server must be specified. The database converter can connect to PostgreSQL server using either local or remote mode. The first one is used to connect to the server launched on the same machine where PostgreSQL to Oracle database converter is running. The second mode allows to connect to the server launched on another computer.

By default the program uses local connection mode. It is indicated by radio button "Local". To set up remote connection select "Remote" radio button. Remote connection requires host and port to connect through. Host could be either network name or IP address. Port value is necessary only if it differs from the default PostgreSQL port 5432. Otherwise this field may be kept "as is".

Finally, user name and password are entered.

This wizard page is designed to specify connection settings for Oracle server:

• Server - IP address or network name of the Oracle server. If the PostgreSQL to Oracle conversion tool has been installed on Oracle server machine, "127.0.0.1" or "localhost" must be specified in this box.
• Database name - the name of Oracle database. Use the same name as when connecting with SQLPlus or any other standard Oracle applications.
• Port - Oracle port, must be specified only if non-default value (1521) is used.
• Username - Oracle username
• Password - Oracle password

On this wizard page source PostgreSQL database must be specified. If user has sufficient permissions to list databases on PostgreSQL server, drop down the combo box to select database from the list. Otherwise, type the database name in the field.

Also, log file to write execution traces of PostgreSQL to Oracle conversion process can be specified on this page. Click 'Browse' button to locate file through the directory tree. Leave this field blank to disable logging.

 
4. Conversion Settings

This wizard page is designed to specify PostgreSQL schema (drop down the combo box to select from list or enter it manually) and customize the conversion process using the following settings:

• Convert table definitions only - select this checkbox to convert only table definitions of the original PostgreSQL database
• Skip converting indexes - select this checkbox if you don't want to convert indexes
• Make names case sensitive - convert table and column names in case sensitive way. Such names must be enclosed in quotes when composing query
• Do not include schema name - select this checkbox to not include schema name in table names. By default this option is NOT active in order to process tables with same names from different schemas

PostgreSQL to Oracle migration tool allows to choose how to process tables that already exist in the destination Oracle database: overwrite, merge or skip existing tables.

Note: leave schema name blank to convert tables from all schemas. In this case table names will appear in the target Oracle database in SCHEMA.TABLE format.

This wizard page is designed to select PostgreSQL tables for converting into Oracle format.

In the left part of the window there is "Available tables" list box. It contains all available tables of the PostgreSQL database except those that you have been selected already. "Selected tables" list box on the right contains all tables that have been selected for conversion.

To add new PostgreSQL table for migration to Oracle server highlight it in "Available tables" list box and click "Add" button (or double-click the highlighted item). Use "Add all" button to add all available PostgreSQL tables.

To remove a table from "Selected tables" list select it and click "Remove" button. Use "Remove all" button to remove all tables from "Selected tables" list box.