How can I create database tables from XSD files

Question

I have a set of XSDs from which I generate data access classes  stored procedures and more   What I don t have is a way to generate database table from these - is there a tool that will generate the DDL statements for me   This is not the same as Create DB table from dataset table  as I do not have dataset tables  but XSDs

User · Answer

XML Schemas describe hierarchial data models and may not map well to a relational data model. Mapping XSD's to database tables is very similar mapping objects to database tables, in fact you could use a framework like Castor that does both, it allows you to take a XML schema and generate classes, database tables, and data access code. I suppose there are now many tools that do the same thing, but there will be a learning curve and the default mappings will most like not be what you want, so you have to spend time customizing whatever tool you use.

XSLT might be the fastest way to generate exactly the code that you want. If it is a small schema hardcoding it might be faster than evaluating and learing a bunch of new technologies.

User · Answer

The best way to create the SQL database schema using an XSD file is a program called Altova XMLSpy  this is very simple     Create a new project On the DTDs   Schemas folder right clicking and selecting add files Selects the XSD file Open the XSD file added by double-clicking Go to the toolbar and look Conversion They select Create structure database from XML schema Selects the data source And finally give it to export the route calls immediately leave their scrip schemas with SQL Server to execute the query    Hope it helps

User · Answer

Create a Java Model using Axis wsdl2java  which can take in  xsd files    Use a database generation tool for Java that takes in a Java Model  Surely something like Hibernate can do this  I wrote my own tool  takes a couple of days  also generates CRUD code in Java too  to save myself time at work  maybe this would be a nice personal project   Or just do it manually so that you can check everything is correct and good  Database tools are good enough now that you can zip through creating tables for a model without too many problems

User · Answer

Commercial Product   Altova s XML Spy   Note that there s no general solution to this   An XSD can easily describe something that does not map to a relational database   While you can try to  automate  this  your XSD s must be designed with a relational database in mind  or it won t work out well   If the XSD s have features that don t map well you ll have to  1  design a mapping of some kind and then  2  write your own application to translate the XSD s into DDL   Been there  done that   Work for hire -- no open source available

User · Answer

hyperjaxb  versions 2 and 3  actually generates hibernate mapping files and related entity objects and also does a round trip test for a given XSD and sample XML file  You can capture the log output and see the DDL statements for yourself   I had to tweak them a little bit  but it gives you a basic blue print to start with

User · Answer

Might take a look at the XSD tool in visual studio 2k8    I have created a relational dataset from an xsd and it might help your out somehow

User · Answer

XML Schemas describe hierarchial data models and may not map well to a relational data model. Mapping XSD's to database tables is very similar mapping objects to database tables, in fact you could use a framework like Castor that does both, it allows you to take a XML schema and generate classes, database tables, and data access code. I suppose there are now many tools that do the same thing, but there will be a learning curve and the default mappings will most like not be what you want, so you have to spend time customizing whatever tool you use.

XSLT might be the fastest way to generate exactly the code that you want. If it is a small schema hardcoding it might be faster than evaluating and learing a bunch of new technologies.

User · Answer

I use XSLT to do that  Write up your XSD then pass your data models through a hand written XSLT that outputs SQL commands  Writing an XSLT is way faster and reusable than a custom program  script you may write   At least thats how I do it at work  and thanks to that I got time to hang out on SO

User · Answer

There is a command-line tool called XSD2DB  that generates database from xsd-files  available at sourceforge

User · Answer

hyperjaxb  versions 2 and 3  actually generates hibernate mapping files and related entity objects and also does a round trip test for a given XSD and sample XML file  You can capture the log output and see the DDL statements for yourself   I had to tweak them a little bit  but it gives you a basic blue print to start with

[.net] How can I create database tables from XSD files?

Examples related to .net

Examples related to sql

Examples related to database

Examples related to xsd

Examples related to code-generation