I had a situation where we have two different DBs with Table-A (on DB1) & Table-B (on DB2). I have to merge both tables to a single new table (Table-C on DB1 or DB2 or NewDB).
Here Table-A & Table-B are PK enabled & need the same on Table-C. Just want to know few suggestions/approaches on how to handle PK conflicts while in merging process.
1) Approaches/suggestions to merge these tables.
2) Approaches/suggestions to handle PK conflict records during this merge process.
Kindly provide detailed explanation in doing this.