title: Efficiently moving large sets of data between SQL Server tables?
body: <p>I have a rather large (many gigabytes) table of data in SQL Server that I wish to move to a table in another database on the same server.</p>
  
  <p>The tables are the same layout.</p>
  
  <p>What would be the most effecient way of going about doing this?</p>
  
  <p>This is a one off operation so no automation is required.</p>
  
  <p>Many thanks.</p>