Re: Oracle to Pg tool

Where do people want this. Should it be in /contrib or on its own web
page?

I have an Xbase conversion utility too. Where should that go?

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026