Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 7,2000 » Replication » Replication:
Add to briefcase

Replication: Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Alone
Posted Thursday, April 01, 2010 4:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:10 AM
Points: 21, Visits: 200
why transactional replication works only on primary key tables.

Why we can't include any non primary key table as an article in replication
Post #894572
steveb.
Posted Thursday, April 01, 2010 5:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:42 AM
Points: 2,802, Visits: 7,103
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.
Post #894597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.