Solved

XML to MS SQL

Posted on 2004-09-01
4
415 Views
Last Modified: 2013-11-23
Does anyone know of a utility or program code to convert XML to MS SQL?
0
Comment
Question by:CalvinDay
4 Comments
 
LVL 15

Expert Comment

by:mattisflones
ID: 11960884
Why did you post this under delphi?

You can use the import functions in MSSQL manager to import your data, or you could set up a DTS if you want to make a standard procedure out of it.
0
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 11961487
XML is just a data format. All you have to do is read the data from the XML file and insert it into records in your SQL database. But I feel you need something more specific so please, be more specific, okay?
0
 
LVL 2

Author Comment

by:CalvinDay
ID: 11964494
You are right. I should have asked this question under the XML area.

However, I do want to open the XML file and insert it. I am using MS SQL administrator and do not know how to link to this file. I have tried to import the data but I get some error from CR XML 3.6 ODBC driver but get errors when it is accessed.
0
 
LVL 26

Accepted Solution

by:
EddieShipman earned 250 total points
ID: 11967186
Well, there is a problem with schemas. If they do not match, you won't be able to use DTS. You are going to
have to have some kind of "mapper" to assign the correct XML fields to the corresponding MSSQL fields.

I believe the XMLDataMapper does that but I only have D6 Pro so I can't create you a sample.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question