Welcome to the Toad Data Modeling Community
Advanced Search - Help - Search Toad World
Welcome, Guest
Login Login / Register
Help
NEW? Get Plugged In

Forums » Join Discussions About... » Toad Data Modeler

Thread: Captions lost for FKs during model convert

This question is answered.


Permlink Replies: 3 - Pages: 1 - Last Post: Oct 29, 2009 3:43 AM by: modelingadmin
AndreasL

Posts: 49
Registered: 2/25/09
Captions lost for FKs during model convert
Posted: Oct 20, 2009 3:54 AM
 
  Click to reply to this thread Reply

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


vladka


Posts: 1,738
Registered: 2/20/07
Re: Captions lost for FKs during model convert
Posted: Oct 20, 2009 4:18 AM   in response to: AndreasL
Answered
  Click to reply to this thread Reply

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


moakes

Posts: 254
Registered: 11/29/07
Re: Captions lost for FKs during model convert
Posted: Oct 27, 2009 3:07 AM   in response to: vladka
 
  Click to reply to this thread Reply

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



modelingadmin

Posts: 101
Registered: 2/14/07
Re: Captions lost for FKs during model convert
Posted: Oct 29, 2009 3:43 AM   in response to: moakes
 
  Click to reply to this thread Reply

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


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums