Hi,
As I previous searched a tool to convert Oracle database to PostgreSQL
and really found nothing, there's now a piece of perl code I've written
that
can become a great tool to do this job.
It currently extract the database schema table definition of an Oracle
database
and output a sql script to import into postgresql. You simply provide the
DBI
connection to the Oracle DB and the script do its best. It normally handle
unique, primary and foreign keys.
I need help to go further because I really don't know about Oracle and I go
very slowly. Also I did not have so much Oracle database to test with.
Things to do are:
- Extract grants (coming soon)
- More precision in type conversion based on length (I've no good DB to do
that)
- Extract triggers and internal function.
- Extract datas.
- SQL queries converter.
For extracting data if someone know a way to dump content of an Oracle DB
in ascii. I don't found anything than binary dump. Extracting them with
perl/DBI
can be very slow but if there's no other way...
You can found this tools at:
http://www.samse.fr/GPL/ora2pg/
Regards