For the life of me, I can’t seem to find a simple tool that will allow me to generate a DDL from an XSD definition. I’ve checked out XML Spy, StylusStudio and even the entire suite of Rational Products (Rational Software Architect & Rational Data Architect). It seems like this option was present in older versions but I can’t find it in v7.0.
Sigh. I guess I’ll just use a utility to connect to the database and create the tables and then extract the DDL.
If you are looking for XML Schema to DB table creation, then that is a feature of XMLSpy: http://www.altova.com/manual2007/XMLSpy/SpyEnterprise/index.html?createdbstructurebasedonschema.htm
Hi sirrahzil,
I’m so happy you stopped by. The weird part about XMLSpy generating a DDL is that it requires a connection to the database in order to generate. I didn’t have an oracle driver installed. I would have thought that generating a DDL was independent of a physical connection to a database.
It sparked a little discussion here about if a connection is actually needed or if the idea of generating a DDL without a connection was oversight.