Visio 2003 ERM to SQL Server script

Question

Hello, my question is simple:

Is there anyway to generate the database sql creaton script from a Visio 2003 model?

I prefer Visio, however can be other program (freeware) that allows me to somehow agilize the process between the model and the sql code.

Thanks in advance!

Answer 1

I could be wrong, but I think the commands to generate DDL disappeared with Visio 2003. Apparently you now need the "Enterprise Edition" or some such dreck.

Also, this is a repeat of this question , and the original pointed to this free service: http://aboutwhatever.net/posts/visio-2007-database-model-ddl-generation which does allow you to do what you want, with certain restrictions.

Answer 2

Once upon a time, there was Visio for Enterprise Architects.

There is a promising add-in for Visio 2010.