title: Fast dump SQL Server Table
body: <p>I have a big table in SQL Server 2008 R2. It contains billions of rows. I need to load the whole data set in our application. Query the whole table is very slow. I want to use bcp dump it into a file and load it. But the problem is there are string columns it contains all kinds of special characters like '\t', '\0', comma, and '\n'. I can't find a good field/row terminator. But long string terminator slows down the data file loading for my application. The question is:</p>
  
  <ol>
  <li>Is there any API that load data faster then SQL query? I find there is a native importing API IRowsetFastLoad. But not lucky on exporting.</li>
  <li>Is there any API for BCP native format? I can't find any document about the format of native bcp file.</li>
  </ol>