title: Data Movement SQL Server
body: <p>In SQL Server 2008 R2, I have two tables <code>Table_A</code> &amp; <code>Table_B</code>. </p>
  
  <p><code>Table_A</code> has 20 million records &amp; <code>Table_B</code> is empty with same structure of <code>Table_A</code>. I want to move the records from <code>Table_A</code> to <code>Table_B</code> with condition (90 days previous records,  15 million records) without any performance issue. What would be the best solution to move the data? </p>
  
  <p>Data has to be deleted from <code>Table_A</code> once it got moved to <code>Table_B</code>.</p>