Replicating child table but not the parent table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Replicating child table but not the parent...

Replicating child table but not the parent table

Rate Topic

Display Mode

Topic Options

Author

Message

psteja2000

Posted Tuesday, January 10, 2012 1:52 PM

SSC 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

azdzn

Posted Tuesday, January 10, 2012 2:50 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 2:10 PM
Points: 1,493, Visits: 240

http://msdn.microsoft.com/en-us/library/ms180843(v=SQL.100).aspx

Post #1233571

psteja2000

Posted Tuesday, January 10, 2012 4:10 PM

SSC 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

azdzn

Posted Tuesday, January 10, 2012 11:09 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 2:10 PM
Points: 1,493, Visits: 240

What kind of replication do you want to use ?

Post #1233726

psteja2000

Posted Wednesday, January 11, 2012 2:43 PM

SSC 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 »

Permissions