I want to replicate data .
This is the example data
I want to replicate Pname1 with a different P_ID
The data should be replicated in all the tables.
lets say we replicate Pname1 and the new P_id is 16. this is how the tables should look now.
Once it is replicated. I will change Pname and Fnames for the new id 16.
I want to know how can achieve this.
Thanks in advance.