any tool for converting XSD to SQL

Hello,

I am looking for some tools or wrapper, which makes it possible to create SQL Tables or Views for a XML Schema.

The only thing i have found was from Altova, but it costs money.

xml tool schema sql

asked 08 Jun '12, 09:20

DavidSteiman
61●2●2●7
accept rate: 0%

Mark Culp
24.8k●9●139●295

flat view

One Answer:

Some freeware possibilities:

xsd2db and Visual Studio 2008- see here.
ixsd2db - see here.
If you create the schema yourself, you can use SQL Anywhere's OPENXML() procedure to shred the XML and generate a relational result set that you can load using INSERT FROM SELECT.

permanent link

answered 08 Jun '12, 09:43

Glenn Paulley
10.8k●5●76●106
accept rate: 43%

flat view

Your answer

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

sql ×90
xml ×29
schema ×25
tool ×3

question asked: 08 Jun '12, 09:20

question was seen: 27,748 times

last updated: 15 Mar '13, 19:52

SAP SQL Anywhere