title: How to resolve primary key collision while merging one db with other
body: <p>I am having my application deployed on two separate regions say US-WEST and EU, both application has its own DB. And now I want to move the EU region DB to US-WEST.</p>
  
  <p>This will lead to primary key collision since both the db has the tables with same primary auto increment id, can anybody give me suggestion to solve this.</p>
  
  <p>Scenario:
  User Table from DB1(say from US-WEST) has the following entries</p>
  
  <pre><code>ID Name 
  1  Rob
  2  San
  3 Tulip
  </code></pre>
  
  <p>User Table from DB2(say from EU) has the following entries</p>
  
  <pre><code>ID Name  
  1  John
  2  Michael
  3  Natasha
  </code></pre>