How to maintain referential integrity when parents tables keys are changed?
<p>I have created a C# app that makes a clone copy from an MS Access database and migrates the data to another DB server, but that will require changing the primary keys.  What is the best way to maintain the referential integrity to the child tables when the parent tables keys are changed?</p>

<p>Thanks,</p>

<p>Andrew</p>
