I have 3 dump files from 3 different machines pc1, pc2 and pc3. I am trying to sync the data from the 3 dump files with the database on my server but, unfortunately the dump files have similar unique ids for different records, because they are on different machines. When merging, the data from the dump file, overwrites the data on my server(if they have the same unique id). Is there a way for creating new records for the records that has the same unique id but different data fields. If no if there are other 3rd party tools for that? What I have tried: I have found a similar question but it gave one of 2 solutions: 1. Either to replace the repeated rows 2. Or to skip the repeated records And no one of the above is suitable for me. I need to create a new record for the repeated rows with repeated unique ids but different other data field values </pre>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)