Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm having som test databases running Oracle 10 & 11 that I plan to try to migrate to PostgreSQL.

Some googling hinted that the perl script "ora2pg" could be of use, and free of charge. However, now I've spent too much time trying to get that running on my winx64 machine, since MinGw won't compile it and activeperl modules hates me.

Are there any other worthy, free, tools to take a look at or should I get a Linuxbox up & running and try ora2pg that way?


share|improve this question

migrated from May 3 '12 at 13:15

This question came from our site for professional and enthusiast programmers.

You could ask EnterpriseDB when using one of their products, you pay for support anyway. – Frank Heikens May 3 '12 at 10:14
Well, no, I use postgresql, not EnterpriseDB. If it will work though, I might consider it in an upcoming case – elwis May 3 '12 at 10:26
Oracle -> PostgreSQL != Oracle -> EnterpriseDB. EnterpriseDB offers a suite of Oracle emulation features not present in Vanilla PostgreSQL. You might also look at Fyracle, which is a version of Firebird with Oracle emulation functionality. – ConcernedOfTunbridgeWells May 3 '12 at 13:36
I changed the subject and the question to reflect the comment about using PostgreSQL and not the "Advanced Server" from EnterpriseDB – a_horse_with_no_name May 3 '12 at 14:59
Additionally, VirtualBox + Linux distro of your choice = perhaps a solution for you to run this script? – swasheck May 3 '12 at 16:15

You should try to make ora2pg work. It's best tool for this, possibly the only one. Also, if you can't get that to work, you will probably have problems using many other possible tools for PostgreSQL. Try to get help sorting these issues out, and you will be able to use the right tools.

share|improve this answer
haven't made it work yet. I'm not a perl guy unfortunately. I installed the environment on two different linux machines and one windows and it won't work on any of them. Ora2pg says that there are no oracle driver, and cpan says it's no luck there. – elwis May 8 '12 at 19:28
Did you get it to work in the end? I managed to install ora2pg in Debian 7 but when I run it, the output.sql that I get is almost empty. I don't get any errors though... – Stelian Iancu Jan 10 '14 at 9:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.