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!

Register Log in
  • Congratulations Chriss Miller 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

lah3233

MIS
Joined
Jul 15, 2003
Messages
33
Location
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!
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smak1
  • Locked
  • Question Question
add structure to XML
Replies
0
Views
1K
smak1
smak1
Bijan Borazjani
  • Locked
  • Question Question
XML to PDF
Replies
0
Views
1K
Bijan Borazjani
Bijan Borazjani
cdr_greg
  • Locked
  • Question Question
Display XML Line Breaks in Microsoft Word Content Controls
Replies
0
Views
1K
cdr_greg
cdr_greg
P
  • Locked
  • Question Question
How to re-use a recursive template
Replies
1
Views
1K
pdrapeau
P
198709km
  • Locked
  • Question Question
Grouping XML key value using XSLT
Replies
1
Views
1K
atlopes
atlopes

Part and Inventory Search

Sponsor

Back
Top