SQL Forward Engineering with Visio

After spending much time modelling an ERD in Visio 2007, you can imagine my frustration at discovering that the Professional edition is not able to generate the SQL DDL! However, Google and Doug Boude came to the rescue with this post which makes use of the Orthogonal Toolbox provided by Orthogonal Software to export the ERD to XML and an XSLT nicely formatted for SQL Server 2005.