How to configure replication if we have identity column in publisher

  • Pls Help me in this regard.

    How to configure a replication if we have a Identity column in a publisher table. As a new DBA I am not able to understand about this problem.

    is there any problem occurs if we configure replication

    this for a table which contains Identity column.

    Any help will be appreciated.

    Thanks in advance.

  • In transaction replication, identity column is automatically managed by the sql server. It allocates a range for publisher and different set of ranges for subsribers.

    For p2p replication, you need to manage it yourself.

    see this: http://technet.microsoft.com/en-us/library/ms146907.aspx%5B/url%5D



    Pradeep Singh

  • Thanks for ur reply.

    could u pls explain me how to manage in P2P replication.

    thanks a lot.

  • Pls go through attached Microsoft whitepaper on P2P replication.



    Pradeep Singh

  • rames.net (6/22/2009)


    Thanks for ur reply.

    could u pls explain me how to manage in P2P replication.

    thanks a lot.

    This article by Paul Ibison explains various methods to manage Identity Range in P2P replication.

    personally i prefer the first method by reseeding the identity range using dbcc checkident.

    http://www.replicationanswers.com/P2PIdentities.asp%5B/url%5D



    Pradeep Singh

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply