Physical -> Logical Model Conversion - Missing table & column comments

Toad Data Modeler
1

When converting a physical data model (MySQL 5) to a logical data model, it seems that the table and column descriptions are not migrated to the logical model. I am using version 3.3.7.22. I have checked the entity and attribute descriptions on both ends of the model before executing.

Is this a bug or am I doing something wrong? If this isn’t possible today, and isn’t a bug can it be added as an enhancement?

Thanks,

Chris

2

Hello Chris,

Let me explain.

Notes in PER model are Description in LER model - and they are converted.
Please check out the Notes tab in your MySQL model and then the Description tab in your LER model.

Comments in PER model (comments in MySQL db, description in MS SQL db…) exist only in physical model (they are generated in SQL script). They do not exist in logical model therefore they are not converted.

If you have any questions, please write me back.
Thanks.

Regards,

Vladka + TDM Team

3

Hi Vladka,

Thanks for your response. Is there any workaround method to mass update the logical descriptions with the physical descriptions? Our model is large and started on an early version of data modeler - exists as PDM only. It would be very difficult to copy and paste descriptions for all entities and attributes into the new LDM.

Thanks,

Chris

4

Hello Chris,

Yes, this is possible via scripting.
Please find attached a script that will go through all entities and attributes in your physical model and copy their Comments to Notes. Comments will be copied to Notes only provided that the Notes section in particular entity/attribute is empty.

Run the script in Scripting Window (Tools menu, Expert mode must be turned on.)

Then feel free to convert the PER model to LER model. Description section will contain the comments then.

Note: Let me draw your attention to this script line:
var Model = app.Models.GetObject(0);
//… parameter in GetObject determines with which model the script should work.
//0 = first model listed in the Application View, 1 = second model listed in the Application View etc.

If you have any questions, please write us back. Thanks.

Regards,
Vladka
TransferCommentsToNotes.zip (618 Bytes)

5

Perfect, the script worked great. Many thanks.

Chris