Thanks Borislav and Brandon,
I looked through and tried some of these ideas but most require the table structures to already be there. We tried to import from the VistaDB database also, but kept running into errors. I will probably just end up creating my own little routine to move the records.
Thanks
Tim
>>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
>
>
>
http://support.microsoft.com/kb/316005>
http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx>None of them tested :-)
Timothy Bryan