title: How can I export huge tables from SQL (SSMS) to a (compressed) file?
body: <p>I am working on SSMS v17.5 and have several very large tables (around 200 GB storage, 350 million rows) in my data base.I would like to save some storage on the data base by exporting some of them to a network drive. 
  The export wizard does not seem to give the option to export directly to a compressed file, is there a possibility to do that with bcp? Or is it possible to export the data to a different file type? How much space would that take (more or less than in DB?) 
  It needs to be possible to reimport the data to the SQL db if needed. </p>
  
  <p>Thanks for your help!</p>