Toad World® Forums

Captions lost for FKs during model convert


#1

After simple model convert from MySQL5 to Oracle9 all captions of foreign keys are reset to ID instead of staying equal to name.

TDM 3.4.14.6

Regards,
Andreas


#2

Hello Andreas,

Yes, this problem was fixed in Beta 3.5.2.10.
Thanks.

Problem Description: Mapped foreign key had different name and caption after conversion (e.g. during conversion from MySQL 5 to Oracle 10g).
Fixed. CR # 65 797

Regards,

Vladka


#3

Hi Vladka,

I guess this is the problem I am seeing with Sync&Convert Merge Models in 3.4.15.10

Since I am not allowed to move to the Beta for production code, is it possible to customise a function to fix this. If so which function?

Regards
Malcolm


#4

Hi Malcolm,

unfortuntely, this bug cannot be fixed via scripting. But it may be possible to write some “workaround script” that will e.g. iterate all attributes in FK and if Name is different than Caption and the Caption is equal with Caption of parent attribute, then the script will modify the Name. If you need help with the script, let us know.

Regards,

Vaclav