CODEWITHSUNDEEP
.netsqlxmlvisual-studio
Daniel Revell
Daniel Revell

Reputation: 8586

Turn an XML file into an MS SQL Server DB

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?

Upvotes: 2

Views: 1020

Answers (2)

Ivo
Ivo

Reputation: 3436

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

Upvotes: 2

Mitch Wheat
Mitch Wheat

Reputation: 300719

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?

Upvotes: 2

Related Questions