Обсуждение: Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration .

Поиск
Список
Период
Сортировка

Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration .

От
mahesh s
Дата:
Hi All,
is anyone using/used  Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration . i am finding lot of difficult. i have oracle Linux  OS and oracle 12 c db. i am trying to migration oracle 12 c to PostgerSQL 10.4 as per document steps.i am not able
could you any one help me out . i will really appropriate your help

Regards
Mahesh

Re: Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration .

От
Francis Santiago
Дата:
Could you tell me a little more, what exactly does not work for you? I have tried both and it works super well. In the case of Ora2pg, at least when I tested it, it does not migrate the packet as such, if not from the procedures inside it.

El vie., 29 de jun. de 2018 a la(s) 10:33, mahesh s (mahesha.bha@gmail.com) escribió:
Hi All,
is anyone using/used  Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration . i am finding lot of difficult. i have oracle Linux  OS and oracle 12 c db. i am trying to migration oracle 12 c to PostgerSQL 10.4 as per document steps.i am not able
could you any one help me out . i will really appropriate your help

Regards
Mahesh


--
Francis del Carmen Santiago Cermeño 
Ingeniero  en Informática 
Certification PostgreSQL 9.3 Associate
Certification PostgreSQL 9.4 Professional
Certification EDB PostgreSQL Avanced Server 9.6 Associate
Twiter: sancfc
Celular: +56952456172
LinkedIn


RE: Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration .

От
"Mario Soto Cordones"
Дата:

Hi,

 

The tool ora2pg, is very good and easy to use, you should have no problems. I use it to migrate from oracle to postgresql and i have never had problems.

 

Regards

 

Mario

De: Francis Santiago <santiagocfc@gmail.com>
Enviado el: viernes, 29 de junio de 2018 10:47
Para: mahesha.bha@gmail.com
CC: pgsql-admin@lists.postgresql.org
Asunto: Re: Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration .

 

Could you tell me a little more, what exactly does not work for you? I have tried both and it works super well. In the case of Ora2pg, at least when I tested it, it does not migrate the packet as such, if not from the procedures inside it.

 

El vie., 29 de jun. de 2018 a la(s) 10:33, mahesh s (mahesha.bha@gmail.com) escribió:

Hi All,

is anyone using/used  Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration . i am finding lot of difficult. i have oracle Linux  OS and oracle 12 c db. i am trying to migration oracle 12 c to PostgerSQL 10.4 as per document steps.i am not able

could you any one help me out . i will really appropriate your help

Regards

Mahesh


 

--

Francis del Carmen Santiago Cermeño 

Ingeniero  en Informática 

Certification PostgreSQL 9.3 Associate

Certification PostgreSQL 9.4 Professional

Certification EDB PostgreSQL Avanced Server 9.6 Associate

Twiter: sancfc

Celular: +56952456172

LinkedIn

 

 

Re: Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration .

От
bhanu prabhakar
Дата:
Hi Mahesh, 

If you are on AWS cloud:

Before proceed migration just do one thing, install AWS sct tool, provide source: Oracle and Target details: postgress and generate the report for each schema, it will provide you complete information. Then use dms service migrate the data schema to schema.

If you are not a AWS cloud user:

We have Dell sharplex replication tool, which will help you replicate(nothing but migrations), most of the  data easily.

Above are the best two options which will be easier than ora2pg, as I don't see well detailed report in ora2pg and I'm not aware edb mkt tool. Thank you.

Regards
Bhanu P Murari

On Fri, Jun 29, 2018, 8:03 PM mahesh s <mahesha.bha@gmail.com> wrote:
Hi All,
is anyone using/used  Ora2Pg or edb MTK tool for oracle to PostgreSQL db migration . i am finding lot of difficult. i have oracle Linux  OS and oracle 12 c db. i am trying to migration oracle 12 c to PostgerSQL 10.4 as per document steps.i am not able
could you any one help me out . i will really appropriate your help

Regards
Mahesh