Note: To post to a thread, you must be logged in.
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
See:
http://www.objectrolemodeling.com/WebLog/tabid/58/EntryID/63/Default.aspxhttp://www.objectrolemodeling.com/WebLog/tabid/58/EntryID/62/Default.aspxhttp://www.orthogonalsoftware.com/toolboxaddons.html
Scot.
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" ?>
Okay, I'm doing something wrong. FYI, I have Viseo Pro 2003.
I created a table called crap, gave it a crap_ID, crap_details, crap_code column and nothing else. I tried exporting and got the same error.
FYI, I -am- using the XSLT that transforms the XML into a DDL SQL... I'm sure this is an easy one, so let me know your thoughts and thanks for your help in advance. I really want to get this to work... I told one of our developers that we weren't going to do this in SQL because I could do this in Viseo and parse out the SQL. I hope I am still right. :)
Hey Scot,
I sent the vsd, xml and xslt to you. Let me know if there's something else that I can provide. I'm sure it's something simple on my end that I'm overlooking.
Thanks,
Travis
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.
dig