Can Visio Forward Engineer Addin be used to create views?

Apr 27, 2011 at 7:26 PM

Currently when I use Visio Forward Engineer Addin, my views are created as a table without respecting the original SQL statement to create the views in Visio.

Is this a limitation? or is this a bug?

Jun 24, 2011 at 2:45 PM

You can create views using the  MODELENGlib.dll.  The class IVMEEntity has a Type property.  If the Type property is eVMEKindERView, it is a View, not a table.

I don't know if this is implemented in this solution, but I have created my own version, and it does work for views.  However, I can't see a way to access user defined types (UDTs) or column attributes (comments).  UDTs are an issue especially as SQL 2008 now allows for Table type UDTs.

If anybody knows of a solution, please post it on this forum.

 

Regards

 

John