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.
Asked
Active
Viewed 8,187 times
0
-
See http://stackoverflow.com/questions/61233/the-best-way-to-shred-xml-data-into-sql-server-database-columns?rq=1 – Dijkgraaf Sep 05 '13 at 23:43
-
Also, some details of XML and table structure required for detailed answers. – Nat Sep 06 '13 at 00:12
-
1possible duplicate of [Importing data from XML file to SQL database](http://stackoverflow.com/questions/10795787/importing-data-from-xml-file-to-sql-database) – Kirk Broadhurst Sep 06 '13 at 00:50
-
I was not able to insert a picture of the schema. – Paul Dokken Sep 06 '13 at 16:16
2 Answers
1
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.
0
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/
Community
- 1
- 1
sudhansu63
- 6,025
- 4
- 39
- 52