I read somewhere that I could use this tool to export to XML then take the XML and create the sql script to create the tables and relationship that I have setup in Microsoft 2002 Visio professional. Is this possible and if so how? Thanks

I have no problems using the tool, but I have no idea what to do with the XML file that I've created. 

I am new to XML, but not to SQL, etc...

FYI, I tried the instructions for the XSLT page, but here's the error that I get:

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

---

Invalid at the top level of the document. Error processing resource 'file:///C:/Documents and Settings/triffle/Desktop/test...

  <?xml version="1.0" encoding="UTF-8" ?> 

I had the same issue. I simply had to copy the .xslt file in the same folder as my .xml file and change the <?xml-stylesheet type="text/xsl" href="OTERtoSQL.xslt"?> line in the .xml file.

I assume that have the .xslt file in the default "Program Files" folder may cause reference error for Internet Explorer. My .xml was on a network share also. This combine with the .xslt file being on the C: drive may have cause a path error or something.

By putting everything in the same folder solved it. I've been able to view the script all right. I just need to beautify it a little to make it human readable, other than that, DDL looks good.

Thanks for the tool, saved me a lot of time.

Pierre.