Post reply

Missing Primary key at subscriber - Transactional Replication

  • February 27, 2011 at 9:09 pm

    #235749

    Hi folks,

    In our environment we have transactional replication setup.I need to add the articles to the existing replication.During this process i generate the snapshot only for the added new articles.

    The issue is when i add the articles individually the primary key donot show up at the subscriber....

  • March 1, 2011 at 8:05 am

    #1292955

    Do you manually create the tables on the subscriber or do you let the snapshot agent create it for you? For Transactional replication, the tables need to have PK. So this looks very strange that you are not getting the PK created on the Subscriber.

    -Roy

  • October 6, 2014 at 6:56 am

    #1750296

    Guys,

    I am also facing the same issue at the subscriber that the primary key is missing in transactional replication.

    I am allowing the snapshot to create the table instead of doing it manually. (SQL Server 2012)

    Kindly suggest.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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