2

There are lots of lovely things Visual Studio can do that I don't know about. There is one thing I'm looking for that it may or may not be able to do.

I'm being passed an XML file and I need to display it as a web form. I'll probably build this in ASP.NET MVC because it'll make it quick and simple to do the CRUD operations. I need to add some persistence so I should really convert the schema of the xml file into a single or multiple tables in a SQL Server database.

Not that doing this manually is a problem, but is there a tool or technology I'm unaware of that will help with something like this?

Daniel Revell
  • 7,974
  • 14
  • 53
  • 91

2 Answers2

2

As a first step XML Schema Definition Tool (Xsd.exe) will create the XSD.

XSD2DB: See How can I create database tables from XSD files?

Community
  • 1
  • 1
Mitch Wheat
  • 288,400
  • 42
  • 452
  • 532
2

You can use SQLXMLBulkLoad for this see http://support.microsoft.com/kb/316005

Ivo
  • 3,333
  • 4
  • 31
  • 56