Hi all,

Some folks were wondering recently if there is a program
that will generate a complete DDL script of a database
that can be used to recreate that database on a database server.
I was reading some .Net stuff last night and discovered that Visio 
Enterprise Architect (part of Visual Studio .Net Enterprise 
Architect Edition) can. Visio EA lets you begin with an Object Role
Modeling diagram, transforms the ORM diagram into an Entity 
Relationship diagram, and generates a complete DDL script from the ER 
diagram which it stores in a .DDL file. The .DDL script can then be run
in SQL Server Enterprise Manager. You can also reverse engineer an 
existing database to its ER diagram and start the process from there.
Visio Pro will do the reverse engineering, but not the DDL script.

Pretty cool. And all for $2,400.