title: Export large amounts of data to client in asp.net
body: <p>I need to export a large amount of data (~100mb) from a sql table to a user via the web. What would be the best solution for doing so? One thought was to export the data to a folder on the db server, compress it (by some means) and then provide a download link for the user. Any other methods for doing so? Also, can we compress data from within sql server?</p>
  
  <p>Any approaches are welcome.</p>