Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication: Expand / Collapse
Author
Message
Posted Thursday, April 01, 2010 4:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 2:12 AM
Points: 27, Visits: 260
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
Posted Thursday, April 01, 2010 5:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
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