Convert XSD into SQL relational tables

Question

Is there something available that could help me convert a XSD into SQL relational tables? The XSD is rather big (in my world anyway) and I could save time and boring typing if something pushed me ahead rather than starting from scratch.

The XSD is here if you want to have a look. It's a standardized/localized format to exchange MSDS.

possible duplicate of [How can I create database tables from XSD files?](http://stackoverflow.com/questions/138575/how-can-i-create-database-tables-from-xsd-files) — Yahoo Serious, Jul 04 '13 at 11:35

score 12 · Accepted Answer · edited May 23 '17 at 11:45

Altova's XML Spy has a feature that will generate SQL DDL Script from an XSD file. XML Spy will cost you some money though.

Interestingly enough, a developer used a really clever trick of using an XSLT translation to create the DDL script from an XSD file. They have outlined it in two parts here and here.

I might have to try this out myself for future use...

EDIT: Just found this question asked previously here...

score 1 · Answer 2 · edited May 23 '17 at 12:25

1

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

For more info: please refer to this existing question How can I create database tables from XSD files?

edited May 23 '17 at 12:25

Community

1
1

answered Feb 25 '14 at 12:57

user3194532

687
7
7

score 0 · Answer 3 · answered Aug 12 '15 at 22:45

You can use an XSLT transform. See, for example, here: Generating SQL from XSD and XSL stylesheets with XSLT.

Microsoft has a command-line tool for performing XSLT transformations: Microsoft Command-Line tool for XSLT.

It is also easy to integrate the transforms into a build process using MSBuild or Grunt.

Here is the reference for the Microsoft documentation: XML Standards Reference, including XSD, XSLT, etc.

Convert XSD into SQL relational tables

3 Answers3

Linked