Book a Demo

Author Topic: Database datatype conversion fails  (Read 2513 times)

Hendrik G.

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Database datatype conversion fails
« on: June 21, 2013, 07:13:48 pm »
Hello people,

I've got a little problem with mapping DB data types.
I have a database model for the Oracle DBMS and want to convert it to PostgreSQL. This works pretty well, except for the data type RAW, which just will not be converted correctly...
In the Database datatype map i've set that Oracle's 'RAW(n)' (common binary) should be converted to PostgreSQL's 'bytea' (common blob).
Now I rightclick the package in the 'Project browser' and select 'Code Engineering -> Reset DBMS Options' and select 'Convert DBMS Type' from Oracle to PostgreSQL. Additionaly I check the 'Process Child Packages'.
In the end, all data types are converted correctly, except RAW(n), which became a RAW [without (n)], but not the correct bytea...

I don't know how to fix this problem.. I see only the possibility , to fix this by hand,  or with a self-written application that relies on the API.
I think that both are not the ideal way, the EA should do it right from the beginning....

Hopefully someone can help me and explain what I need to do ...

Best regards from Germany
Hendrik G.