Thursday, September 13, 2012 3:40 PM
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
Thursday, September 13, 2012 4:00 PMModeratorNo, 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