title: Violation of UNIQUE KEY Constraint in SqlBulkCopy Execution
body: <p>I am trying to develop a solution to automate the migration of data from several client databases to a central database of the same structure using SqlBulkCopy in C#. It threw an exception of "Violation of Unique Key Constraint" because some tables have got unique key columns with some unique values in them (that I completely understand).</p>
  
  <p>So my major challenge now is to somehow get the program to skip the record coming from the source database (client DB) that has a duplicate unique key on destination database (central DB), get the corresponding Primary Key Value on the destination 
  database (central DB) and overwrite the primary key value of the skipped record on all tables (in the client DB) in which it exists as a foreign key.</p>
  
  <p>This is my biggest challenge I have ever faced in my software development experience yet. And to whoever that can help me out of this, I will be forever in your debt.</p>
  
  <p>Thanks.</p>