CODEWITHSUNDEEP
sql-serverxml
Paul Dokken
Paul Dokken

Reputation: 1

Read XML data into SQL Server database

I have created an Adobe LiveCycle form that collects the form data into an XML file. I would like to read this XML data into a SQL Server 2008 database. The format of the data is a parent table with 2 child tables. What are the options for getting the data into a database.

Upvotes: 0

Views: 8194

Answers (2)

GWhite
GWhite

Reputation: 426

Your question is nearly identical to Importing data from XML file to SQL database.

You could try the 2008 version of the SQL Server Import/Export Wizard.

If you know how to write code, almost every programming language has a way to talk to a database and SQL server should be supported by all of them.

Upvotes: 1

sudhansu63
sudhansu63

Reputation: 6180

There are 2 ways read data from xml file For SQL Server 2008

1.Using xquery

2.Using OpenXML

How do you read XML column in SQL Server 2008?

Read XML document stored in SQL Server 2008 R2 with XML datatype

http://blog.sqlauthority.com/2009/02/13/sql-server-simple-example-of-reading-xml-file-using-t-sql/

http://blog.wharton.com.au/2011/05/27/part-2-openxml-what-is-it-and-how-do-i-use-it/

Upvotes: 0

Related Questions