Re: migrate off oracle data to postgres

2020-03-31 Thread JC JC
. From: Pepe TD Vo Sent: 31 March 2020 17:45 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List ; JC JC Subject: Re: migrate off oracle data to postgres @JC - I do have ora2pg set up last year in test environment already and that what I suggested team using insert

Re: migrate off oracle data to postgres

2020-03-31 Thread Pepe TD Vo
ersjc From: Pepe TD Vo Sent: 31 March 2020 16:51 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List ; JC JC Subject: Re: migrate off oracle data to postgres I have tables ddl data definitions already.  Only need to move the data over off Oracle to Postgres Bach-Nga No one in this world is pur

Re: migrate off oracle data to postgres

2020-03-31 Thread JC JC
From: Pepe TD Vo Sent: 31 March 2020 16:51 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List ; JC JC Subject: Re: migrate off oracle data to postgres I have tables ddl data definitions already. Only need to move the data over off Oracle to Postgres Bach-Nga No one in this world

Re: migrate off oracle data to postgres

2020-03-31 Thread Virendra Kumar
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.

Re: migrate off oracle data to postgres

2020-03-31 Thread Adrian Klaver
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.kla...@aklaver.com

Re: migrate off oracle data to postgres

2020-03-31 Thread Pepe TD Vo
my limited experience I never encountered any issue on the limit on data being transferred, but definitely the load time vary depending on the environment. Regardsjc From: Pepe TD Vo Sent: 31 March 2020 15:15 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List Subject: migrate off oracle

Re: migrate off oracle data to postgres

2020-03-31 Thread JC JC
vary depending on the environment. Regards jc From: Pepe TD Vo Sent: 31 March 2020 15:15 To: Pgsql-admin ; Pgsql-general ; PgAdmin Support List Subject: migrate off oracle data to postgres Hello, I have a huge data on Oracle, would you please suggest how

Re: migrate off oracle data to postgres

2020-03-31 Thread Jan Birk
tir, 31 03 2020 kl. 14:15 +, skrev Pepe TD Vo: > I have a huge data on Oracle, would you please suggest how to migrate all data > off Oracle to Postgres? Do I need to export into csv and upload to postgres? > Ora2pg is limited data from oracle to postgresql right? How huge is huge? We have u

Re: migrate off oracle data to postgres

2020-03-31 Thread John Wiencek
You should explore EnterprisDB’s Migration ToolKit (MTK). Regards John Wiencek > On Mar 31, 2020, at 9:15 AM, Pepe TD Vo wrote: > > Hello, > > I have a huge data on Oracle, would you please suggest how to migrate all > data off Oracle to Postgres? Do I need to export into csv and upload to

migrate off oracle data to postgres

2020-03-31 Thread Pepe TD Vo
Hello, I have a huge data on Oracle, would you please suggest how to migrate all data off Oracle to Postgres?  Do I need to export into csv and upload to postgres?  Ora2pg is limited data from oracle to postgresql right? Bach-Nga No one in this world is pure and perfect.  If you avoid people fo