Re: Oracle to Pg tool

On Wed, 9 May 2001, Bruce Momjian wrote:

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

This is already linked on the related page.

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

What's the URL?

>
>
> > 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
> >
>
>

--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================