Post reply

Replication:

  • April 1, 2010 at 4:25 am

    #100125

    why transactional replication works only on primary key tables.

    Why we can't include any non primary key table as an article in replication

  • April 1, 2010 at 5:03 am

    #1143822

    because the replication agent needs a way to unqiuely identify the rows, otherwise how would the replication agent know what row to update on the subscribers?

    also it is expected that in any relational database that all tables will have a primary key, otherwise you really need to look at your design because you are going to run into issues at some stage, whether you use replication or not.

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

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