Reverse Engineer SQL2008 Database to Diagram

Question

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

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

thx.

Answer 1

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)

Answer 2

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