I have 2 publisher namely TH1, TH2
1 subscriber : THFinal
I've created 2 individual publications using "Create Publication" and published database namely TH1 and TH2.
Publication type : Merge publication
Default table article properties setting are as follows :
a. When merging from different sources : "Treate changes to the same column as a conflict (changes to different columns in the same row will be merged)".
i Choose "DELETE DATA IN THE EXISTING TABLE that matches the ROW FILTER statement".
I checked "yes" for - Allow Subscribers to resolve conflicts interactively during on-demand synchronizations".
Now, when i sync the TH1, all the records from TH1 goes to the subscriber database "THFinal".
When i sync the TH2, all the records which was synched earlier (from TH1) being DELETED. and all the records from TH2 goes to the subscriber database "THFinal".
Basically, i WANT to retain the ALL THE data from in "THFinal" which came from TH1 database since the primary key is different. Also, all the database contains running no (Identity increment = 1) . Will it cause any havoc when replicating since running no will be same in TH1 and TH2 even though the primary keys for the table is unique?
Again, i really appreciate for your kind help.