SSDN - How to transfer and store XML data to SQL SERVER

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

yesu seelam

Subject: 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.

Ivan Pedruzzi

Subject: 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

yesu seelam

Subject: 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,

Ivan Pedruzzi

Subject: 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

Shannon M

Subject: 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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.