Post reply

How to configure replication if we have identity column in publisher

  • June 22, 2009 at 9:15 am

    #211205

    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.

  • June 22, 2009 at 9:21 am

    #1013385

    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

  • June 22, 2009 at 9:48 am

    #1013410

    Thanks for ur reply.

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

    thanks a lot.

  • June 22, 2009 at 10:37 am

    #1013443

    Pls go through attached Microsoft whitepaper on P2P replication.


    Pradeep Singh

  • June 22, 2009 at 10:41 am

    #1013447

    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