Problem solve Get help with specific problems with your technologies, process and projects.

Migrating from Oracle 9i to PostgresSQL 7.3.4 using Ora2Pg

Unix-to-Linux migration expert Ken Milberg gives advice on how to use Ora2PG for preserving information in databases transitioning from Oracle 9i to PostgresSQL 7.3.4.

How can I migrate a database from Oracle 9i to Postgres 7.3.4?

What you need is Ora2Pg, which is a Perl module that is used to export an Oracle database schema to a PostgreSQL-compatible...

schema. It connects to your database, extracts the structure of the database and generates a SQL script that you can import into your Postgres database. It can dump the actual database schema (tables, views, sequences, indexes, grants), without editing the SQL code generated.

Ora2Pg is also capable of discharging the data in an online transaction, where one can choose what columns can be exported for each table. Features include database schema export (tables, views, sequences, indexes), grants/privileges export by user and group, data export and the SQL query converter. Best of all, the program is free and you can modify it under the same terms as Perl itself. Some more useful documentation on details of the process can be found here.

This was last published in December 2005

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.