title: Merge identical databases into one
body: <p>We have 15 databases of 75 tables with an avarage of a million rows. all with the same schema but different data. We have now been given the requirements by the client to bring all 15 into one database. Each set of data filtered by the user’s login.</p>
  
  <p>The changes to the application have been completed to do the filtering. We are now left with the task of merging all databases into one. </p>
  
  <p>The issue is conflicting PK and FK as the PK’s and the FK’s are of type int so we will have 15 PK ids of 1.</p>
  
  <p>One idea is to use. net and the DBML to insert the records as new records into the new database letting linq deal with the PK and FK and using code to deal with duplicate data.</p>
  
  <p>What other ways are there to do this?</p>