Create a SQL Database from XML

• gerciang

  SSC Veteran

  Points: 229

  More actions

  February 21, 2011 at 11:45 pm

  #247065

  Hello,

  I would like to know if it is at all possible to create a SQL Database from XML and if, how to go about doing it ?

  Thank you

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 2, 2011 at 1:56 pm

  #1293733

  Do you have an XSD for your XML?

  If not you can derive one using SSMS. Open your XML document in SSMS and from the XML menu (only shows when in in an XML document tab) choose "Create Schema". That will give you a starting point.

  Using your XSD and some tips in this article about adding SQLXML annotations to your XSD you can generate tables in SQL Server:

  http://blogs.msdn.com/b/monicafrintu/archive/2007/06/12/how-to-create-tables-in-a-database-using-an-xsd-schema-and-sqlxmlbulkload.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato