Visio & SQL 2005 some oddities

I have been working with the Visio for Enterprise Architects. I have a project that I’ve been using it for documentation on. I need to prepare a document for management on the project and I began with a clean reverse engineer. But while looking at the reports and I noticed some oddities.

Several of the tables have notes. They are just erroneous notes from where I imported the tables from the original db from a sql server 7 but they are there. I have yet to figure out where they are on the 2005 server.

Not a single column has any of the descriptions that I put on them on the server. I would have assumed that on a clean reverse engineer they would have imported the descriptions and inserted them into the notes section of the column.

My questions are: how do I get the description flowing both ways from the SQL 2005 server and Visio How do I get said description on the reports Where do I view the table related notes in 2005 SQL management studio



Answer this question

Visio & SQL 2005 some oddities

  • Visio & SQL 2005 some oddities