1.5.1 MS Access migration: different type relationships to constraints BUG?
663305Oct 3 2008 — edited Oct 8 2008
MS Access allows for relationships (key/foreignkey) between tables on columns of a different datatype.
It seems the access migration tool is translating these relationships to Oracle constraints in the target DDL script. This results in an error when the DDL is executed: ORA-02267: column type incompatible with referenced column type.
Quick migrate will fail too ofcourse.
Workaround is to edit the DDL by hand and delete the constraint statements or to remove the relationship from MS-Access.
It should be possible for the Access exporter to skip generating a constraint for these different-type relationships.