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.
4
-
See stackoverflow.com/questions/61233/…Dijkgraaf– Dijkgraaf2013-09-05 23:43:30 +00:00Commented Sep 5, 2013 at 23:43
-
Also, some details of XML and table structure required for detailed answers.Nat– Nat2013-09-06 00:12:40 +00:00Commented Sep 6, 2013 at 0:12
-
1possible duplicate of Importing data from XML file to SQL databaseKirk Broadhurst– Kirk Broadhurst2013-09-06 00:50:32 +00:00Commented Sep 6, 2013 at 0:50
-
I was not able to insert a picture of the schema.Paul Dokken– Paul Dokken2013-09-06 16:16:41 +00:00Commented Sep 6, 2013 at 16:16
Add a comment
|
2 Answers
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.
Comments
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/
