Reverse Engineering Column Notes into Visio from SQL Server 2005  
Author Message
scottnmead





PostPosted: Modeling and Tools, Reverse Engineering Column Notes into Visio from SQL Server 2005 Top

I would like to reverse engineer a database schema from SQL Server 2005 into Visio 2003 and populate the notes property for both the Tables and individual Columns. I have discovered that if you create an extended property called 'Notes' in SQL Server on the table definitions, that the notes property in Visio is populated correctly. However, if I do the same thing for a column, it does not populate the notes property within Visio. Does anyone know of a way to have the Notes property of a column definition populated from SQL Server 2005 into Visio

Thanks, Scott Mead



Architecture2