Migrating from Oracle to PostgreSQL

This video presents Ora2Pg, a free tool that you can use to migrate an Oracle database to a PostgreSQL compatible schema. Ora2Pg connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.

Ora2Pg can be used from reverse engineering Oracle database for database migration or to replicate Oracle data into a PostgreSQL database. The video shows where to download it and talks about the prerequisites. It explains how to install Ora2Pg and configure it. At the end, it presents some examples of ora2pg being used.

Video Producer: http://marakana.com/

Related Content:

3 thoughts on “Migrating from Oracle to PostgreSQL

  1. is there a video that shows how to connect to oracle and transfer data please?
    Thank you

  2. Is it possible to migrate only data to the postgresql database
    Because I have already designed my schema in the destination postgresql databse.
    In that case what is the best possible way to migrate only datas
    with primary key and foreign keys to postgresql .

Comments are closed.