What tools are available to convert XML or JSON structures to SQL?
-
Tools for creating SQL statements, or running them, based on XML or JSON. Preferably command line, Unix-paradigm tools.
-
Answer:
Though there are many free tools available online (like http://www.xml-converter.com), you can easily write a small php (or in python or in any other scripting languages) script file on your own to get it done, with more degrees of freedom
Sravan Reddy at Quora Visit the source
Other answers
To convert XML data into SQL tabular format: - Convert a table to XML and back to tabular format: http://sqlwithmanoj.com/2011/01/28/select-an-xml-to-table/ - Query XML data in tabulat format: http://sqlwithmanoj.com/2011/07/13/query-xml-string-in-tabular-format/ - Query Nested XML: http://sqlwithmanoj.com/2011/07/13/select-or-query-nodes-in-hierarchial-or-nested-xml/ - Using APPLY operator: http://sqlwithmanoj.com/2011/09/22/more-examples-on-querying-xml-with-cross-apply-xquery/ - Read XML from a file: http://sqlwithmanoj.com/2011/10/20/save-xml-in-a-file-read-xml-from-a-file/ - XML with Namespaces: http://sqlwithmanoj.com/2011/11/02/adding-namespaces-in-xml-querying-xml-with-namespaces/ - Export XML to a file: http://sqlwithmanoj.com/2015/04/13/export-xml-column-data-to-a-file-xml/
Manoj Pandey
you can convert xml or you json file into CSV file and then you can impoert that csv file into you sql data base .. here is a web service which you can use to convert you xml or json file into csv. http://online-formatconverter.rhcloud.com/converter/xmltojson.jsp http://fileformat-converter.com
Udit Saini
Related Q & A:
- What Games Are Available On NHL Vault?Best solution by nhl.com
- How to convert XML files to PDF files?Best solution by Super User
- How to convert xml to json in c#?Best solution by Stack Overflow
- What jobs are available in Blythe,CA?Best solution by indeed.com
- What tools does anthropologist use?Best solution by wiki.answers.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.