哪个工具可以帮助从E-R图生成SQL Server 2005/2008数据库？

In Visio 2003 Architect version I can generate a SQL Server Database on the fly from UML ER diagram. But there is no such a way by using Visio 2007. My question is: Any other good and latest tools can support ER-> DB or DB->ER very well for SQL2005/2008?In Visio 2003 Architect version I can generate