Solved

XML to MS SQL

Posted on 2004-09-01
4
413 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now