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.
Related Posts
- How not to migrate your server - Internal Database Copying
- BPEL: Beware the use of nested loops in a short running process
- WebSphere Adapter for JDBC Export and SQL Server 2000: Table Locking while Polling
- Tip: Agree To Concrete WSDL Definitions before Development Begins
- CWSIP0311E: A user is not authorized to delete a durable subscription
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
July 10th, 2008 at 10:52 am
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
July 10th, 2008 at 11:03 am
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.