I have an existing database that I am trying to put into data modeller.
The existing field names are fine for working with the database, but on diagrams, they leave alot to be desired.
In the table/column description is a more descriptive name for the entity/attribute and I would like to be able to automatically pull the appropriate text from the description and place it into the caption.
For example, I have a table
Which has a description of
Original Entity Name : Product Requirements
Physical Entity Name : A0034B
Baseline View : POREQIDEN
Creation Date : Friday,June 8, 2012
Model Style : Physical, 4th NF
And every table and column in the database has a description such as the above.
I would like an automated method to pull the Caption from the description.
I was looking at the data model library but from the description, it can only be used to read the data model project, not used to update the project.
Is there any example code available to perform a task like this?