SQL Schema to XML Schema?
Is there a tool that will take a typical SQL schema (Oracle, in this case)
What I did for some DB synchronization tools I had to implement is to read the system tables and create an XML file. I am not sure but it might be possible to dump a XML schema directly from Oracle.
So far, I've never seen an automatically generated xml schema that didn't completely suck.
thanks, I've been doing it by hand, and it is relatively straightforward, but the data model is HUGE. i've got some emacs macros to assist me, but it still seems hugely tedious for a data model of non-trivial size. i'm going to grab a copy of "xmlspy" to see if that can help me. anyone used xml spy for this purpose? the goal/purpose is actually have to produce an XML model of our data for a due dilligence review, etc.... sigh.
Fog Creek Home