search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
991 stars 342 forks source link

ora2pg does not convert anydata #1642

Open did16 opened 1 year ago

did16 commented 1 year ago

Ora2Pg v23.2 does not convert Oracle Anydata type to PostgreSQL: --- Oracle CREATE TABLE "CTR"."TQ_ACTIV" ( ... "USER_PROP" "SYS"."ANYDATA" , ... --- PostgreSQL CREATE TABLE tq_activ ( ... user_prop ANYDATA

anydata is not a postgresql type

darold commented 1 year ago

Right, converting this depend of the use but such all-in-one data type do not exists in PostgreSQL. Some are converting it to json but my opinion is that an extension should be developed to emulate this datatype. The other solution is to modify the application logic and design to avoid the use of such insane column.