title: Transfer large amount of data from a SQL Server database to MongoDB periodically
body: <p>I have a table in a SQL Server database which contains large amount of data, around 2 million records (~approx 20 columns for each row). The data in this table gets overridden at the end of each day with new data.</p>
  
  <p>Once the new data is available I need to copy this data from the SQL Server database to a MongoDB table. </p>
  
  <p>The question is on the way by which it can be achieved the fastest?</p>
  
  <p>Some options :</p>
  
  <ul>
  <li>A simple application that reads and writes</li>
  <li>Some sort of export/import tool.</li>
  <li>Generating a\multiple file\s from SQL and then reading concurrently to import in MongoDB </li>
  </ul>