Hi AllI am new to XML. The source application stores data in SQL Server 2005 in XML datatype column. We have to extract and load the XML data into relational tables for faster querying and reporting for a data warehouse. We do have an XSD file from the application developer. Now our tasks are:1. Create tables (data model) in SQL Server 2005 to load extracted XML data.2. Map XML data to various columns in these newly created tables.3. Extract XML data from the XML column.4. Load data to newly created tables for further transformation.Now the questions are:1. Is there a tool that can convert XSD to SQL DDL? Doing it manually will be very time consuming. (FYI: We are exploring Altova XMLSpy - which is a potential candidate)2. How can I map data from XML to relational table columns? Is there a tool that can help me there? Does XSLT file help in achieving this goal? What is the best approach?3. What is the best way to extracrt XML data and load it to relational SQL tables? Suggestions will be appreciated.ThanksGary
