title: How can I copy data records between two instances of an SQLServer database
body: <p>I need to copy some records from our SQLServer 2005 test server to our live server.  It's a flat lookup table, so no foreign keys or other referential integrity to worry about.</p>
  
  <p>I could key-in the records again on the live server, but this is tiresome.  I could export the test server records and table data in its entirety into an SQL script and run that, but I don't want to overwrite the records present on the live system, only add to them.</p>
  
  <p>How can I select just the records I want and get them transferred or otherwise into the live server?  We don't have Sharepoint, which I understand would allow me to copy them directly between the two instances.</p>