I was trying to use db2db to transfer tables from postgresql database to oracle database. Although, it migrated most of the tables and their data but it failed in situations where the data types supported by the two databases are different.
For example, one of our tables support "bytea" in postgres whereas this needs to be converted to "blob" in oracle. I am not able to find out as to where do we specify this "data mapping". I tried using the Edit -> Data Type Mappings option but i was not able to successfully use it.
Can anyone please help me out here?
Thanks,
Rachna Aggarwal
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I was trying to use db2db to transfer tables from postgresql database to oracle database. Although, it migrated most of the tables and their data but it failed in situations where the data types supported by the two databases are different.
For example, one of our tables support "bytea" in postgres whereas this needs to be converted to "blob" in oracle. I am not able to find out as to where do we specify this "data mapping". I tried using the Edit -> Data Type Mappings option but i was not able to successfully use it.
Can anyone please help me out here?
Thanks,
Rachna Aggarwal