On Tue, Jan 30, 2018 at 02:53:44AM +0000, Karl Stubsjoen wrote:
I'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-schem... In the mean time it can at least show the value in selecting the right corners to cut. ;) Regards, Ben