Post by Karl StubsjoenI'd like to convert Xml Schema's directly to Sql Table scripts and
simple CRUD operations. I will write my own stylesheets to do this
but figured I'd check first with support to see what is available.
Unfortunately when you Google it, only the "other" product pops up
as having a solution.
One of the perks of not dealing directly with the systems engineering
world is not needing to fix someone else's broken db ... but I
digress. Those years did, however, drill home the value of anything
which does (or comes close enough to do) for SQL databases what oXygen
does for XML, will always be worth keeping on hand.
Navicat (ideally the Premium edition) is still the winner there, even
here where OS constraints prevent installing the latest version.
Unfortunately it's OS X and Windows only, but it makes the damned
things less painful. The conversion method is basically follow the
prompts and does plenty more than XML.
A bit over two years ago I stumbled across a mostly undocumented XML
schema in a project I contribute to. Shortly after that, I generated
schema files for it with oXygenXML Editor. So I figured I'd use that
to demonstrate what Navicat's import does. Attached is the XSD
version of the schema and the subsequent dump file created after
importing into a test server (only the db server host address has been
changed).
The source material is in one of my git branches until we decide
if/when to set a global xmlns for future releases. That branch is
here:
https://git.gnupg.org/cgi-bin/gitweb.cgi?p=gpgme.git;a=tree;f=lang/xml-schemas;h=6306cd1dca1cfacb5a97ac80848fcc216622bfb1;hb=003c3f24fd6ef19e6e7042d461232c33a6f83150
In the mean time it can at least show the value in selecting the right
corners to cut. ;)
Regards,
Ben