maintain key values
So i have multiple tables that have foreign keys. Let's say for example, there's an ID field and 2 tables with a 1:N relationship on that ID. I need to take that data in and replace the IDs, but i need to make sure that the records in the two tables still maintain that relationship. So if it replaces 123 with 456 (randomly) i need to be sure that it will ALWAYS replace 123 with 456. That needs to operate within the tables too; for instance, on the N side of the relationship i might have 20 records all with ID 123. All of them need to be 456 at the end.
0 · Share on Twitter