No text data type for ERD

i am trying to make an erd, i found out that, there is no TEXT data type in Visual paradigm 7.0 sp1, for an ERD. You can select most of the types like int, boolean, varchar, tinyint but there is nothing like TEXT.

Any suggestions will be greatly appreciated.

|ALKINDI|

Hi Alkindi,

Thanks for your post. Please select Tools > Options > Object-Relational Mapping (ORM) > Database Configuration and select the database (MySQL, MS SQL, Sybase, PostgreSQL). After that, you will see the datatype “text” available for selection in Type field in Column Specification dialog.

BTW, Database Configuration is available in VP-UML/SDE Professional Edition (or above) and Database Visual Architect (DB-VA).

Hope this helps. Feel free to have a post if there is any further inquiry.

Best regards,
Lilian Wong



Please see above image, it seems like i don’t have database configuration, even when i have visual paradigm for UML.

ayub_zar,

My guess is that the menu navigation is as follows: Tools -> Object-Relational Mapping (ORM) -> Database Configuration. That is, don’t go into Options.

Hi Ayub Zar,

D6chung is correct that I wrong type the menu items, it should be Tools > Object-Relational Mapping (ORM) > Database Configuration. Sorry for my mistake.

Best regards,
Lilian Wong

it worked but i made it hard way in MS WORD due to dead line, thanks for correction d6chung.

|ALKINDI|