Skip to main content
Solved

How can we save huge xml response into DB?

  • Jan 6, 2021 2:43 PM UTC
  • 3 replies
  • 138 views
  • Translate All

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Jan 6, 2021 3:02 PM UTC

Hi @lakshmim85,

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

Translate

  • Author
  • Freshman I
  • Jan 7, 2021 12:29 PM UTC

Hi @Naveen B ,

Please find the xml response as an attachment here. 

Thank you!

Translate

  • Freshman I
  • Answer
  • Feb 11, 2021 12:06 AM UTC

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

Translate