Search code examples
sql-server-2008reverse-engineeringdiagram

Reverse Engineer SQL2008 Database to Diagram

Visio 2007 support reverse engineering a MSSQL Database. However, SQL2008 is not supported (link).

Are there other (free?) tools that can do this?

thx.

Solution

  • The SQL Server Management Studio Tool can do it.

    1. Attach the DB
    2. Expand its node
    3. Right click Database Diagrams -> New Database Diagram

    N.B: You'll need to be logged in as a dbo and have the database diagramming components installed (Management studio will tell you if not)