Chad Osgood's Blog

Chad Osgood's Old, Expired Blog

Generating a database schema from an XML schema

I have been looking for xsd2db, a tool for generating a database schema from an XML schema, ever since I read this article.  Unfortunately, when it came time for me to recall the location of the tool I had forgotten where I found it in the first place (I'm sometimes lazy on my bookmarks).  Thanks to Mike Gunderloy's most recent Daily Grind, I was able to locate the tool.

It works as promised, and I was able to create a database with the appropriate entities for a few complex types defined in my XSD for a SQL Server database and an Access database. 

Posted: May 27 2003, 10:33 PM by ChadOsgood | with 12 comment(s)

Comments

TrackBack said:

.NET Blog - Chris Frazier Style
# May 27, 2003 11:33 PM

Alexis Smirnov said:

Chad,
What other features would you like to see xsd2db?
# May 29, 2003 9:49 AM

Christopher said:

How does xsd2db handle annotated DataSets?

ref: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingannotationswithtypeddataset.asp
# June 3, 2003 6:50 PM

Chad Osgood said:

It doesn't do anything with the annotations from what I can tell, but that's understandable as it would have to account for the any number of annotations people have used in their XSD, including the annotated DataSet.

I'm not certain if the author of the tool is wanting this tool to be geared more towards .NET, or if it's meant to be more of a general tool. In the former case, facilities could be added to handle things like annotated DataSets, ExtendedProperties, etc.
# June 3, 2003 7:42 PM

Alexis Smirnov said:

First off, the intention behind xsd2db is to be use .NET and be useful in the context of .NET development. Specifically this means the tool will continue to use DataSet as in-memory representation of XSD schema. There are no plans to create a new object model for XSD as part of this project.

Regarding DataSet annotations, currently xsd2db ignores them. Adding support for annotations is an excellent feature suggestion. Christopher, feel free to add it here: http://sourceforge.net/tracker/?func=add&group_id=81795&atid=564048
# June 4, 2003 10:58 AM

bnaya said:

I didn't managed to operate this product
can you add some samples/instruction
tnx
# January 6, 2004 1:17 AM

Christian said:

I couldn't get it to work as well... Could write a simple readme with examples?

Thanks
# April 29, 2004 6:55 PM

daljeet said:

I need a similar tool for creating a schema for mysql server, can this tool create mysql schema files ?

# July 24, 2007 1:25 PM

Raul Bove said:

1.  It would be better to have this tool als GUI-Tool

2.  Optional it could produce the SQL statements into a  SQL file instead of the direct generation of tables in the database. In this case the tool doesn't need to manage the database. Such a SQL file is necessary for installation procedures.

# August 17, 2007 4:58 AM

Amber said:

How are you. The two symbols of the Republican Party: an elephant, and a big fat white guy who is threatened by change. Help me! It has to find sites on the: Ss share trading. I found only this - <a href="tt.tlu.ee/.../share-trading-courses">share trading courses</a>. Any time who is 15 position to 25 market too on a base and is financial to trade electricity judiciously to return, share trading. Regardssushanta the internet again has a company, share trading. Waiting for a reply :mad:, Amber from Guatemala.

# March 23, 2010 9:46 PM

moon shine said:

thanks a lot

can you help me how can I use xsd2db tool?

thanks in advance

# October 31, 2010 4:40 PM

tryecrot said:

Yes there should realize the opportunity to RSS commentary, quite simply, CMS is another on the blog.

# August 28, 2011 9:53 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)