Tell me more ×
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. It's 100% free, no registration required.
up vote 3 down vote favorite

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?

Regards

share|improve this question
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
2  
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
show 3 more comments

migrated from stackoverflow.com May 3 '12 at 13:15

1 Answer

up vote 1 down vote

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 installed..so no luck there. – elwis May 8 '12 at 19:28

Your Answer

 
discard

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.