title: Import/export data from SQL Server programmatically using C# and ASP.NET
body: <p>I have a web app written with C# to run in an ASP.NET environment. The web app is using SQL Server 2008 database (T-SQL) to store data. It has about 4-5 tables with data. So I was wondering if there's anything in ASP.NET to help me export those tables along with all of their data into a text file (or a memory array) programmatically, as well as subsequently import them back into the SQL Database later (obviously from a file or memory array)?</p>
  
  <p>PS. The reason I need this is to provide a function in the web app itself to import/export data from another copy of the web app that runs on a separate IIS.</p>