Target generated DDL file failing to run

[ajirules]

After 100% compatability , i generated the taregt PostgresSql Sql file. However i am seeing script failing from very first few basic errors.

VARCHAR2(20 ) from Oracle shows the same in the postgressql script . But postgres throws error in execution saying

ERROR: type "varchar2" does not exist

Same goes for Oracle data type NUMBER.

My question is if the tool says compatible and generates the target DDL script , isnt these data type conversions taken care ? Why does the tool say its 100% compatible and gives a generate script option?

[UmangTank]

Hello ajirules,

Migration Portal assess the Oracle DDLs against EnterpriseDB's postgres, which has rich set of Oracle compatible feature on top of Postgres. If DDLs are 100% compatible on Migration Portal, it will run fine on EnterpriseDB's Postgres.

Thanks.

EDB