SQL Server Performance

Merge Replication - help needed

Discussion in 'SQL Server 2005 Replication' started by L0st_Pr0phet, Jul 9, 2009.

  1. L0st_Pr0phet Member

    Hi,
    A client is currently running merge replication between two servers. The publication is only two tables but they use Automatic identity range support a column call ID which also hapens to be part of a composite key.
    Now, the client has a new requirement to replicate the publisher database to a third server. But they do not want any changes for this third server replicating back to the publisher. Is there anyway of doing this? I cant use a different kind of replication because of the Identity range property! I cant un-check this column from the publication because it is part of the composite key.
    Any ideas? all I can think of is trying log shipping, snapshot would be useful but it doesnt let you if you use Automatic Identity range support!
    Cheers
    Stewart
  2. ghemant Moderator

Share This Page