XSD to SQL DDL

• Gagandeep Singh

  SSCommitted

  Points: 1513

  More actions

  September 8, 2006 at 9:46 am

  #90482

  I am new to XML. My question is:

  Is it possible to or is there a tool that can generate a SQL DDL Script or a Logical Data model from the XSD file. I am working on a Reporting DataStore project that requires conversion from XML to relational database for efficient reporting. I do have the XSD already. I want to:

  1. Create a Data Model (SQL DDL) that can load the extracted XML data.

  2. Extract XML from an XML data type column in SQL Server 2005 using XSD file.

  3. Load the extracted XML data to Data Model.

  Any suggestions will be appreciated.

  Thanks

  Gary