Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrate XML to SQL Server

Status
Not open for further replies.

lah3233

MIS
Jul 15, 2003
33
US
What is the easiest way to move data/table structure from an XML file into a SQL Server database?

Is there a way to do it w/o manually creating the tables?

Thanks!
 
I think you could create a script which will do it automatically. Only you should know is ADO and MSXML parser

Ion Filipski
1c.bmp
 
It's been a long time since I've looked at it, but I thought the MSSQL Administrative Front end had an import tool which allowed XML sources, it'll probably ask for some verifications along the way to make sure you're happy with the tables it sets up... but if I remember right it's fairly good.

-Rob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top