title: How to Merge two databases in one in SQL Server 2008?
body: <p>I have 2 PCs, each one of them has SQL Server 2008 installed on it and there is a database with data in it.</p>
  
  <p>I need a way that I can move data in my DB from this SQL Server to another one (another PC which has the same DB)</p>
  
  <ul>
  <li>move data from one PC to another one - </li>
  </ul>
  
  <p>There is one problem, the ID column, because each DB in my 2 PCs has data in it so this column counts from 1,2,3,....... ( data will be conflict with other data in my DB )</p>
  
  <p>Is there any way to solve my problem and move data successfully?</p>