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?
... View more