Postgres 7.4 to Oracle 10g Migration with BLOBs

Поиск
Список
Период
Сортировка
От kashkon@att.net
Тема Postgres 7.4 to Oracle 10g Migration with BLOBs
Дата
Msg-id 102820060205.8365.4542BAFD0000E833000020AD2158766720020105089C0E05@att.net
обсуждение исходный текст
Ответы Re: Postgres 7.4 to Oracle 10g Migration with BLOBs  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-odbc
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
update4 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
checkedthe 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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: Overly enthusiastic use of pg_config
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Postgres 7.4 to Oracle 10g Migration with BLOBs