0 like 0 dislike
129 views
asked by (2k points)  
Hi anyone having idea about migrating database from oracle to postgresql using free tools ?

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (2k points)  
edited by
 
Best answer

we are going to talk about migrating from oracle to postgresql using ora2pg.After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle 12C database and a postgresql edb 9.6, The server is runing on OEL 7.2,The oracle database and the postgresql server are running on the same server.

we are going to talk about migrating from oracle to postgresql using ora2pg open source tool
before migrating you need to know little bit knowledge of functions,procedure,trigger and  Difference between oracle vs postgresql data types

Related questions

0 like 0 dislike
0 answers
0 like 0 dislike
1 answer
Welcome to PostgreSQL Database Discussion Forum where you can ask questions and receive answers from other members of the community. Can discuss here Oracle, Postgresql, mariadb , mySQL , AWS , Linux , MSSQL , MongoDB , Greenplum databases related queries ...etc.
...