PostgreSQL to Oracle Tutorial
|[PostgreSQL to Oracle Converter] [FAQ] [Download] [Buy]|
|1. Connect to PostgreSQL Server
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.
|2. Connect to Oracle Server
This wizard page is designed to specify connection settings for Oracle server:
|3. Select Database
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.
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:
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.
|5. Select Tables
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.