Re: migrate off oracle data to postgres

From: Virendra Kumar <viru_7683(at)yahoo(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>, Pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-general <pgsql-general(at)postgresql(dot)org>, PgAdmin Support List <pgadmin-support(at)lists(dot)postgresql(dot)org>, JC JC <shekharjchandra(at)hotmail(dot)co(dot)uk>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: migrate off oracle data to postgres
Date: 2020-03-31 16:08:55
Message-ID: 380953143.257193.1585670935977@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-general

FDW for oracle and ora2pg both are too slow compared to offload data in a file and load into PostgreSQL. When I was doing one of my migrations I found the best solution was to download data using sqlldr on to the database host where PostgreSQL instance is running and load it using COPY command.

Regards,
Virendra Kumar
On Tuesday, March 31, 2020, 8:55:17 AM PDT, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

On 3/31/20 8:51 AM, Pepe TD Vo wrote:
> I have tables ddl data definitions already.  Only need to move the data
> over off Oracle to Postgres

PostgreSQL Foreign Data Wrapper for Oracle:

http://laurenz.github.io/oracle_fdw/

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message JC JC 2020-03-31 16:09:11 Re: migrate off oracle data to postgres
Previous Message Adrian Klaver 2020-03-31 15:54:46 Re: migrate off oracle data to postgres

Browse pgsql-admin by date

  From Date Subject
Next Message JC JC 2020-03-31 16:09:11 Re: migrate off oracle data to postgres
Previous Message Adrian Klaver 2020-03-31 15:54:46 Re: migrate off oracle data to postgres

Browse pgsql-general by date

  From Date Subject
Next Message JC JC 2020-03-31 16:09:11 Re: migrate off oracle data to postgres
Previous Message Adrian Klaver 2020-03-31 15:54:46 Re: migrate off oracle data to postgres