XML Exported - Large Size

• jevitts

  Mr or Mrs. 500

  Points: 543

  More actions

  October 22, 2014 at 3:44 pm

  #97225

  Hello. I'm running into issues while exporting XML data. I'm not sure if it is a conversion issue (export methods converting XML to varchar) or a decompression issue. I've tried using the FILESTREAM/FileTable option as well as bcp.

  Using datalength() I can see that the data inside the table in an XML column is 1.8MB. Using both FileTable and bcp the file jumps to 11MB, and I lose my XML formatting. Any idea what is the cause of this? I'm currently working on using an XML format file with bcp, will this help my space issues? Any alternative solutions to get my SQL data out in native XML form?

  The client is limiting us to a specific file size, so I need these files as small as possible. In table form, the data is 14k rows by 4 columns with nothing larger than nvarchar(30) - maybe it's just me but 11MB seems a bit excessive!

  Any insight you can provide is greatly appreciated!

  Thanks,
  Jessica
  What would you attempt to do if you knew you could not fail? -Robert H. Schuller