Wednesday, April 13, 2011

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.

From stackoverflow
  • 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)

  • DeZign for Databases can import SQL2008 databases (you can use the 2005 driver, that works)

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.