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.
[youtube w23DrHi0lD0]
Video Producer: http://marakana.com/
Pingback: 2012? 2? 22? it ?? ?? |
is there a video that shows how to connect to oracle and transfer data please?
Thank you
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 .