SSDataWorks 1.0 is a data modelling tool for Microsoft SQL Server 2005 /
2008. SSDataWorks provides a powerful development environment allowing DBAs
and developers to fully define every aspect of their SQL Server database,
including the following features:

- Reverse engineer from T-SQL scripts or a live database.
- Forward engineer to T-SQL script or a live database.
- Visually model and layout fully-attributed entity-relationship diagrams.
- Generate HTML reports to create documentation.
- Advanced scripting through an embedded JavaScript engine to extend
the functionality of the tool (i.e. code generation).

Check it out at http://www.SoftMosis.com