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 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 JC JC
In my view ora2pg can do most of the stuff you requested. ora2pg can be used to generate the DDL from oracle to postgres based on attributes set in ora2pg conf file (for example TYPE TABLE, will allow getting oracle DDL in an output file, TYPE COPY will bring the data). No doubt you need to set