Hi all,

We need to import an XML with schema into a new database on SQL Server 2008. It appears there are some methods of doing this that seem a bit involved. Since this is basically a one time move from one data source into XML and then into SQL server it isn't very appealing to go through 38 steps of creating stuff. I would have hoped there was a import from xml file in SQL server but can't find any such thing.

Does anyone know of a simple import solution?
Thanks
Tim