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@postgresql.org so that your
> message can get through to the mailing list cleanly
>

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