Oracle to Pg tool 
Author Message
 Oracle to Pg tool

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.***.com/

Regards

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 27 Oct 2003 01:12:30 GMT
 Oracle to Pg tool

Add on on ora2pg.

Table grant extraction is done.  It is based on group/users grants.

Oracle has ROLES that I understand as groups and users associated to
these roles. So I create a group for each role and alter it by adding the
users.
And then set grants to each tables.

Let me now if I have to stop to send new update on the list.

Regards

---------------------------(end of broadcast)---------------------------



Mon, 27 Oct 2003 04:52:33 GMT
 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?

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

> message can get through to the mailing list cleanly

--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Mon, 27 Oct 2003 05:18:22 GMT
 Oracle to Pg tool

Quote:

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

This is already linked on the related page.

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

What's the URL?

Quote:

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

> > message can get through to the mailing list cleanly

--
==========================================================================

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Mon, 27 Oct 2003 05:39:53 GMT
 Oracle to Pg tool

Quote:

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

It doesn't have a URL.  It is on our own FTP site.  You can link to it,
I guess, but it probably needs to hit a mirror that always will respond.

The URL is:

        ftp://ftp.crimelabs.net/pub/postgresql/contrib/dbf2pg-3.1.tar.gz

but it is not on the mirrors yet.  My problem is trying to get some
rules on what goes in /contrib and what doesn't.  My assumption is that
loadable modules and stuff that deals with the backend internals go into
/contrib.  That would mean our mysql stuff would be removed, I guess.

--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 27 Oct 2003 05:43:34 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Oracle to Pg tool

2. Oracle to Pg tool

3. Building perl mods pg:PG or DBD:PG on non-PostgreSQLable machines

4. Building perl mods pg:PG or DBD:PG on non

5. 29512-TN-Memphis-ORACLE-ORACLE Forms-ORACLE Tools-ORACLE HR-ORACLE Case Tools-CONSULTANTS

6. 29512-TN-Memphis-ORACLE-ORACLE Forms-ORACLE Tools-ORACLE HR-ORACLE Case Tools-CONSULTANTS

7. 4722-CA-Bay Area-ORACLE Case Tools-ORACLE Forms-ORACLE Reports 2.X-ORACLE Tools-

8. NC-Charlotte-29511--ORACLE-ORACLE Forms-ORACLE Tools-ORACLE HR-ORACLE Case Tools


 
Powered by phpBB® Forum Software