Add Site Location in Merge Replication

Question

Hi All

I have business requirement to merge three identical tables from three different locations (Site A, Site B, Site C).

Can we use merge replication to merge three tables and at destination table add a column(SiteName) to include each respective site ?

for example the destination table will look like:

	SiteName	Column1	Column2	Column3
	Site A	Data	Data	Data
	Site A	Data	Data	Data
	Site B	Data	Data	Data
	Site C	Data	Data	Data
	Site A	Data	Data	Data
	Site B	Data	Data	Data

Thanks All in advance. please let me know if the question is unclear.

---

Thank you -Mushtaq

Answer 1

No, but you could use transactional. You would create a central subscriber and use a custom insert stored procedure that would to a no-op if the row already exists, or do an update if it does. You could also use the continue on data consistency error profile to skip duplicates if the PK is on the SiteID column,

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941