Is it possible to make sql or xml from a Visio-databasediagram?

Is it possible to make sql or xml from a Visio-databasediagram?
- or from other Visio diagrams?

Thanks and regards
Lone Andersen

I was thinking of automatically genereated sql or xml made buy Visio on the basis of a Visiodatabasediagram.
Lone

Hi Lone,

Is it possible to make sql or xml from a Visio-databasediagram?
- or from other Visio diagrams?

Visio for Enterprise Architects (shipped with Visual Studio .Net Enterprise
Architect) will generate SQL DDL.

Also, I have developed an Add-on utility (free, URL below) that will export
this data into an XML format (it does not, however, generate an XSD based on
the model, but rather exports model meta-data as XML).

The next version of this tool, which will be released soon, will support
Visio Professional 2002/2003 as well. Thus, you could use it to generate
your own SQL DDL/XSD by writing XSLT against the XML output the utility
provides.

Hope that helps,
Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.