Generating SQL from Visio (non-Enterprise Architect versions)
Creating an ERD without the ability to generate SQL from it is of questionable value. If you’re not using a CASE tool such as ERwin (and why not?), you may need to generate a DDL from your Visio layout. If typing out SQL statements proves too laborious, here is a great workaround to generate workable SQL from your Visio diagram.
A company called Orthogonal Software has a Visio plug-in called Orthogonal Toolbox that will allow you to export the data from the Visio document to an XML File. Additionally, Orthogonal has provided a couple XSLT’s that you can apply (look for XSLT on that page). One of which has been altered to export SQL.
Once you have the plug-in installed and the XSLT’s downloaded, it’s pretty simple. Use the plug-in to export to XML, and apply the stylesheet when exporting. Presto- DDL statements for your structures.
