[GENERAL] ora2pg and DBD::Pg

Alexandra Roy

unread,

Nov 20, 2009, 11:57:29 AM11/20/09

to

Hi all,

I see in the ora2pg documentation on
http://www.darold.net/projects/ora2pg/ that DBD::Pg is optional and
needed only for 'on the fly' migration.
I need to clarify this...

Does someone can explain me that is under 'on the fly' please ?

Concerning the documentation of ora2pg, is it the good link ?

Thank you for your answer.

Regards,
Alexandra

--
Alexandra ROY
Database Competence Center

Bull, Architect of an Open World TM
Phone: 04 76 29 77 01
http://www.bull.com

This e-mail contains material that is confidential for the sole use of
the intended recipient. Any review, reliance or distribution by others
or forwarding without express permission is strictly prohibited. If you
are not the intended recipient, please contact the sender and delete all
copies.

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Joshua D. Drake

unread,

Nov 20, 2009, 12:24:18 PM11/20/09

to

On Fri, 2009-11-20 at 17:57 +0100, Alexandra Roy wrote:
> Hi all,
>
> I see in the ora2pg documentation on
> http://www.darold.net/projects/ora2pg/ that DBD::Pg is optional and
> needed only for 'on the fly' migration.
> I need to clarify this...
>
> Does someone can explain me that is under 'on the fly' please ?

Never used it but my guess would be... converting straight from Oracle
to PG as they are both running.

>
> Concerning the documentation of ora2pg, is it the good link ?
>
> Thank you for your answer.
>
> Regards,
> Alexandra
>
> --
> Alexandra ROY
> Database Competence Center
>
> Bull, Architect of an Open World TM
> Phone: 04 76 29 77 01
> http://www.bull.com
>
> This e-mail contains material that is confidential for the sole use of
> the intended recipient. Any review, reliance or distribution by others
> or forwarding without express permission is strictly prohibited. If you
> are not the intended recipient, please contact the sender and delete all
> copies.
>
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

Stephen Frost

unread,

Nov 20, 2009, 3:14:33 PM11/20/09

to

* Alexandra Roy (Alexan...@bull.net) wrote:
> Does someone can explain me that is under 'on the fly' please ?
>
> Concerning the documentation of ora2pg, is it the good link ?

It worked well for me, using it mainly to copy table structures and
data. I was doing a one-time move to PG though, not trying to keep
Oracle and PG in sync. I don't recall it being of much help with moving
functions and the like, but that's a much more complicated problem.

Stephen

signature.asc

Alexandra Roy

unread,

Nov 23, 2009, 3:51:17 AM11/23/09

to

Hi all,

And what about "on the fly" please ?
As I encounter compilation problem on AIX 5.3, I am wondering if DBD::Pg
is necessary to use ora2pg...

Thank you for your help,
Regards,
Alexandra

Stephen Frost a �crit :

Andrej

unread,

Nov 24, 2009, 11:51:24 AM11/24/09

to

2009/11/23 Alexandra Roy <Alexan...@bull.net>:
> Hi all,
Hi Alexandra,

> And what about "on the fly" please ?
> As I encounter compilation problem on AIX 5.3, I am wondering if DBD::Pg is
> necessary to use ora2pg...

Josh pointed that out to you 4 days ago. It means "w/o having to save
intermediate
files".

> Thank you for your help,
> Regards,
> Alexandra

Cheers,
Andrej