Skip to main content
Solved

How can we save huge xml response into DB?


Hi All,

I want to save the huge xml response in SQL Server.

At present, I am trying to convert total xml response to string and saving to DB, but here total response is not saving as the content is very very big.
So want to try like saving the response as it is like xml. Is it possible to save like this.. If yes may I know the possibilities / approaches please.


Thanks in advance.

Best answer by FredZhou

basically, XML is stored in string format. people will store XML in a folder, then in data store the url/directory into database.

View original
Did this topic help you find an answer to your question?

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • January 6, 2021

Hi @lakshmim85,

Can you please share the sample XML response file here, will try and let you know if I found anything from myside.


  • Author
  • Freshman I
  • 4 replies
  • January 7, 2021

Hi @Naveen B ,

Please find the xml response as an attachment here. 

Thank you!


  • Freshman I
  • 5 replies
  • Answer
  • February 11, 2021

basically, XML is stored in string format. people will store XML in a folder, then in data store the url/directory into database.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings