title: Data loss warning adding column in the middle of a table
body: <p>A new column has been added to a table, but the new column was not added to the end of the table definition (rightmost column), but the middle of the table.</p>
  
  <p><img src="https://i.stack.imgur.com/spBoT.png" alt="Table differences"></p>
  
  <p>When I try to commit this in Redgate SQL Source Control, I get the warning "These changes may result in data loss"</p>
  
  <ul>
  <li>Will data loss really occurr?</li>
  <li>Is there a way preview the change script to confirm that no data will be lost?
  
  <ul>
  <li>Can I copy the script and easily turn it into a Migrations V2 script?</li>
  </ul></li>
  <li>Will I just have to
  
  <ul>
  <li>Edit the table in SSMS and move the new column to the end</li>
  <li>or write a migration script?</li>
  </ul></li>
  <li>If so, are there any handy tools to do the repetitive stuff?</li>
  </ul>