The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.

asked 08 Jun '12, 09:20

DavidSteiman's gravatar image

DavidSteiman
61227
accept rate: 0%

edited 15 Mar '13, 19:52

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262


Some freeware possibilities:

  1. xsd2db and Visual Studio 2008- see here.
  2. ixsd2db - see here.
  3. 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%20Paulley's gravatar image

Glenn Paulley
10.7k568104
accept rate: 43%

Your answer
toggle preview

Follow this question

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:

×90
×22
×18
×3

question asked: 08 Jun '12, 09:20

question was seen: 5,109 times

last updated: 15 Mar '13, 19:52