xml to sql?

arian · 09-23-2009, 02:06 AM

Hi,

I have 4 xml files corresponding to 6 tables as a database.
I want to change them to sql tables, is there any function included in C# libraries to do it automaticaly?

thanks
arian

Dino · 09-23-2009, 06:21 AM

A side question - What database are you using? Does it support XML as a native format?

arian · 09-23-2009, 09:00 AM

Sorry as I dont have enough knowledge about DataBases, I dont know what you mean by "What database are you using?"
but I geuss the answer to the 2nd question is yes.

I am going to use the converted database (converted to SQL server) in a C# program.

here is a part of 2 of xml files:

Code:

- <SYNSET_RELATIONS>
- <SYNSET_RELATION>
  <ID_1>5002303</ID_1> 
  <ID_2>5002341</ID_2> 
  <RELATION_TYPE>Hyponym</RELATION_TYPE> 
  <STATUS>NotChanged</STATUS> 
  </SYNSET_RELATION>
- <SYNSET_RELATION>
  <ID_1>5001048</ID_1> 
  <ID_2>5001049</ID_2> 
  <RELATION_TYPE>Hyponym</RELATION_TYPE> 
  <STATUS>NotChanged</STATUS> 
  </SYNSET_RELATION>
- <SYNSET_RELATION>
  <ID_1>5000636</ID_1> 
  <ID_2>5002635</ID_2> 
  <RELATION_TYPE>Hyponym</RELATION_TYPE> 
  <STATUS>NotChanged</STATUS> 
  </SYNSET_RELATION>

-----------------------------------------
- <Synsets>
- <SYNSET>
  <ID>5003525</ID> 
  <UID>5100000079</UID> 
  <POS>Noun</POS> 
  <SemanticCategory>Nothing</SemanticCategory> 
  <EXAMPLE>?</EXAMPLE> 
  <GLOSS>علف خوردن حیوانات علف خوار در علف زار و مرتع</GLOSS> 
  <STATUS>Updated</STATUS> 
  <MappedWNsynId /> 
- <SENSES>
- <SENSE>
  <WID>5025527</WID> 
  <SID>0</SID> 
  <STATUS>NotChanged</STATUS> 
  </SENSE>
- <SENSE>
  <WID>5031133</WID> 
  <SID>0</SID> 
  <STATUS>Added</STATUS> 
  </SENSE>
  </SENSES>
  </SYNSET>
- <SYNSET>
  <ID>5003286</ID> 
  <UID>5100000085</UID> 
  <POS>Noun</POS> 
  <SemanticCategory>Nothing</SemanticCategory> 
  <EXAMPLE>?</EXAMPLE> 
  <GLOSS>حقوق: واگذاشته شدن مالي به مالکي جديد و ازبين رفتن مالکيت مالک قبلي</GLOSS> 
  <STATUS>Edited</STATUS> 
  <MappedWNsynId /> 
- <SENSES>
- <SENSE>
  <WID>5030210</WID> 
  <SID>0</SID> 
  <STATUS>NotChanged</STATUS> 
  </SENSE>
- <SENSE>
  <WID>5030211</WID> 
  <SID>0</SID> 
  <STATUS>NotChanged</STATUS> 
  </SENSE>
  </SENSES>
  </SYNSET>

09-23-2009, 02:06 AM	#1
arian Registered User Join Date: Nov 2003 Posts: 109	xml to sql? Hi, I have 4 xml files corresponding to 6 tables as a database. I want to change them to sql tables, is there any function included in C# libraries to do it automaticaly? thanks arian
arian is offline

09-23-2009, 06:21 AM	#2
Dino Jack of many languages Join Date: Nov 2007 Location: Katy, Texas Posts: 1,929	A side question - What database are you using? Does it support XML as a native format? __________________ Mac and Windows cross platform programmer. Ruby lover. Memorable Quotes From Recent Posts: I can't remember.
Dino is offline

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OOP Question DB Access Wrapper Classes	digioz	C# Programming	2	09-07-2008 04:30 PM
Embedded SQL	sarac	C Programming	1	05-04-2006 09:09 AM
XML and data exchange	seexml	C Programming	0	04-27-2006 03:02 PM
functions seems not to exit from a certain code block	jaro	C Programming	1	03-21-2006 07:52 AM
Problem with embedded SQL in C/C++ (ECPG)	NeuralClone	C Programming	4	10-21-2005 05:16 PM