XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
yesu seelamSubject: How to transfer and store XML data to SQL SERVER
Author: yesu seelam
Date: 06 May 2006 09:21 PM
Hi
i am getting xml file from other application.i need to store xml data into sql server without duplicate values please help me out from this issue.
if you have any information and code please forward to me.
Thanks.
yesu.

Postnext
Ivan PedruzziSubject: How to transfer and store XML data to SQL SERVER
Author: Ivan Pedruzzi
Date: 08 May 2006 11:29 AM
Yesu,

Your question is too generic to be answered. You can find entire books dedicated to this topic.

How the XML looks like?

How big is the document?

Does it need to be spread into multiple tables?

Do you need to store it in exiting tables?

Which type is the target column(s)?

Which technology your application is build on? Java, C#, C++, ...

Ivan Pedruzzi
Stylus Studio Team

Postnext
yesu seelamSubject: How to transfer and store XML data to SQL SERVER
Author: yesu seelam
Date: 08 May 2006 01:34 PM
Hi Ivan,
My application is build in Java,
1000 records having the xml document
it needs to be spread into multiple tables
i need to store in existing tables

Yesu,







Postnext
Ivan PedruzziSubject: How to transfer and store XML data to SQL SERVER
Author: Ivan Pedruzzi
Date: 08 May 2006 03:10 PM

Please take a look to SQL/XML UPDATE syntax it may help.

http://www.stylusstudio.com/docs/v2006/d_rdb35.html#wp374745
http://www.stylusstudio.com/docs/v2006/d_rdb.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Posttop
Shannon MSubject: How to transfer and store XML data to SQL SERVER
Author: Shannon M
Date: 09 May 2006 02:40 PM
SQL SERVER in caps, as in the product name? MS SQL, then?

consider the following technologies:

Create an SQL annotated schema, and use SQLXMLBULKLOAD, included with MS SQL Server.

Translate your data to a Diffgram via XLST

Use OPENXML to query the XML source as a rowset from an SQL stored procedure.

If the data comes from a web service, use the new DTS-like functions in SQL Server 2005.

Load it into a .NET DataSet and update SQL from the generated tables.

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.