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

Replicating child table but not the parent table Expand / Collapse
Author
Message
Posted Tuesday, January 10, 2012 1:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 9:26 AM
Points: 26, Visits: 65
Pretty basic(stupid) question, is it possible somehow to make a child table (the one with foreign key constraints) a publication article while NOT including the parent table in the publication?
Post #1233514
Posted Tuesday, January 10, 2012 2:50 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:52 PM
Points: 1,511, Visits: 254
http://msdn.microsoft.com/en-us/library/ms180843(v=SQL.100).aspx


Post #1233571
Posted Tuesday, January 10, 2012 4:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 9:26 AM
Points: 26, Visits: 65
Thank you. So the answer is, If the user application (at subscriber side) is adding a row into the child table, the corresponding parent table MUST be present right?

EX: Products and Orders. Orders has foreign key to Products table.

At subscriber side, can I not have Product table at all? (Just for example) I guess NOT
Post #1233622
Posted Tuesday, January 10, 2012 11:09 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:52 PM
Points: 1,511, Visits: 254
What kind of replication do you want to use ?



Post #1233726
Posted Wednesday, January 11, 2012 2:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 9:26 AM
Points: 26, Visits: 65
merge replication with pull subscribers
Post #1234400
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse