XML Schema (XSD) to Database Definition Language (DDL) Generator?

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.

Author: dan


  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *