title: Select into statement where source is other database
body: <p>How to copy data from one DB into another DB with the same table structure and keep the key identities?</p>
  
  <p>I use Sql Server 2012 "Denali" and I want to copy some data from a Sql Server 2008 DB. The tables I have are exactly the same but I want the data from the old DB into the new "Denali" DB. The databases are on different servers.</p>
  
  <p>So I want something like</p>
  
  <pre><code>USE newDB;
  GO
  SELECT *
  INTO newTable
  FROM OldDb.oldTable WITH (KEEPIDENTITY);
  GO
  </code></pre>
  
  <p>Anyone have a suggestion to make this workable ?</p>