title: SQL Server ID auto generation
body: <p>I have two databases named <code>db1</code> and <code>db2</code> in SQL Server 2008.</p>
  
  <p>Both have a table called <code>customers</code>. <code>db1.dbo.Customers</code> has 9000 records, and <code>db2.dbo.tblCustomers</code> has 3000 records.</p>
  
  <p>I want to insert the 3000 records from <code>db2</code> into <code>db1.dbo.Customers</code>. But I want <code>db1.dbo.Customers</code> to automatically generate <code>Customerid</code>. </p>
  
  <p>Would it be possible?  </p>