Postgres 7.4 to Oracle 10g Migration with BLOBs

Hi,

I need to migrate a 60 GB Postgres 7.4 running on Linux to Oracle 10g running on Linux RedHat Enterprise Linux ES 4 update 4 x86_64 . I need help with a workable solution.
I tried pg_dump but it does not allow dumping blobs for migration to Oracle.
I tried a couple of tools but they do not work.
Oracle does not have a tool to do it for Postgres.

I can only think of using ODBC driver but need help where the ODBC should be installed.

Should it be installed on the Oracle server and should it be a Postgres ODBC? Where can I down load it from? I checked the postgres.org website but it was not clear whehter I needed to download the dll, mm, or msi!

Thanks in advance!

Kourosh Ashkon

--
Kourosh Ashkon
e-mail:kashkon@att.net

---------------------------(end of broadcast)---------------------------
TIP 1: 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

Re: Postgres 7.4 to Oracle 10g Migration with BLOBs

kashkon@att.net wrote:
> Hi,
>
> I need to migrate a 60 GB Postgres 7.4 running on Linux to Oracle 10g running on Linux RedHat Enterprise Linux ES 4 update 4 x86_64 . I need help with a workable solution.
> I tried pg_dump but it does not allow dumping blobs for migration to Oracle.
> I tried a couple of tools but they do not work.
> Oracle does not have a tool to do it for Postgres.
>
> I can only think of using ODBC driver but need help where the ODBC should be installed.
>
> Should it be installed on the Oracle server and should it be a Postgres ODBC? Where can I down load it from? I checked the postgres.org website but it was not clear whehter I needed to download the dll, mm, or msi!

Sad to see you go... but dbi-link is likely your friend here.

Jshua D. Drake



>
> Thanks in advance!
>
> Kourosh Ashkon
>
> --
> Kourosh Ashkon
> e-mail:kashkon@att.net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: 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
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


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

Re: Postgres 7.4 to Oracle 10g Migration with BLOBs

On Oct 27, 2006, at 8:16 PM, Joshua D. Drake wrote:

>> I need to migrate a 60 GB Postgres 7.4 running on Linux to Oracle
>> 10g running on Linux RedHat Enterprise Linux ES 4 update 4
>> x86_64 . I need help with a workable solution.
>> I tried pg_dump but it does not allow dumping blobs for migration
>> to Oracle.
>> I tried a couple of tools but they do not work.
>> Oracle does not have a tool to do it for Postgres.
>>
>> I can only think of using ODBC driver but need help where the ODBC
>> should be installed.
>>
>> Should it be installed on the Oracle server and should it be a
>> Postgres ODBC? Where can I down load it from? I checked the
>> postgres.org website but it was not clear whehter I needed to
>> download the dll, mm, or msi!
>
> Sad to see you go... but dbi-link is likely your friend here.

You'll probably also want to convert the binary data to hex and then
back again, though maybe dbi-link can actually handle binary data
natively.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend