Toad World® Forums

How to migrate FK from LER to PER


#1

I usually do logical schema because I must to generate the physical model for several vendors (Oracle, Mysql).
The thing is that when I “Sycn Convert” to Mysql, I am suprised because FK are not migrate to tables.

How can I fix that?


#2

Hi,

please read the following blog post that explains why FK don’t migrate to child tables:
http://blogs.inside.quest.com/modeling/2010/01/13/model-type-selection-and-why-fks-don%e2%80%99t-migrate-to-child-entities-in-logical-model/

We do support three methods how inheritance can be converted to physical models. If you wish to create a model for multiple vendors, but don’t plan to use inheritance, create a physical model for Oracle and then convert it to MySQL etc. In Toad Data Modeler you can define both logical and physical names for tables - Captions are logical names, Names are physical names. That means, if you create a table in physical model, you can specify caption as Customer and name as CSTMR, for example.

Regards,

Vaclav