XSD To Relational Database Model Converter -- XSD2DB

A requirement in a small project I've been working on recently came up for mapping an XSD directly to an RDBMS schema on the fly (i.e. an incoming XML schema needs to be generated into an RDBMS schema structure at runtime...I won't get into specifics as to why), so I started searching for a way to to do this via the BCL.  The new SQL Server SMO libraries looked promising, however they are vast and patience quickly lost out to a some good ol' one on one Google time.  I ended up stumbling across this tool; even though the last release was 2 years ago so far it has worked quite nicely and it does appear to still be in (somewhat) active development.

Share this post: | | | | |

Only published comments... Jan 21 2007, 05:53 PM by Jayson Knight

Filed under: Technology and Internet, Tools and Resources, Links and News, SQL Server

Comments

Kyle said: This is indeed a great tool.  I used it on a project a couple months ago.  Do pay attention to how text fields are converted to SQL types ... I remember some funkiness around that. January 25, 2007 7:54 AM

About Jayson Knight

Jayson Knight was clueless to the computer programming world until he took a C++ class in college. The rest is proverbial history. He has been building applications targeting the .Net framework for 7 years, focusing mainly on internet technologies and database driven web application development.

Most recently he left the world of Corporate IT to finish up his degree in Chemistry, with an eye on Medical School and an Anesthesiology residency program. Read this post for more information.

He is also a Community Server MVP: Community Server is the software that runs this site, plus many others on the web. For more information, check out http://csmvps.com.

When he finds time to pry himself away from his computer and university studies, he can be found on the mountain bike trails when it's warm, and on the ski slopes when it's cold.