Visio 2007 : Reverse Engineering a SQL Server Database

1) Create Database Diagram >


2) Reverse Engineer >


3) Select the database >



4) Select type of objects to represent in the diagram >


5) Select the objects themselves >


6) Create diagram automatically now?


7) Review selections >


8) Screenshot of the result >



9) The diagram >

.

Database Diagrams (SQL 2005)

A bit primitive at the moment and nowhere near the database diagramming functionality provided in Visio, but its a start. Picking up on defined relationships in a database, here is what it made of a handful of AdventureWorks tables >