Skip site navigation (1) Skip section navigation (2)

Re: Postgres 7.4 to Oracle 10g Migration with BLOBs

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: kashkon(at)att(dot)net
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Postgres 7.4 to Oracle 10g Migration with BLOBs
Date: 2006-10-28 02:16:03
Message-ID: 4542BD63.1090906@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
kashkon(at)att(dot)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(at)att(dot)net
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: 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
> 


-- 

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


In response to

Responses

pgsql-odbc by date

Next:From: lothar.behrens@lollisoft.deDate: 2006-10-29 12:38:40
Subject: Crash on Mac OS X while using MallocDebug ?
Previous:From: kashkonDate: 2006-10-28 02:05:49
Subject: Postgres 7.4 to Oracle 10g Migration with BLOBs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group