Replicating child table but not the parent table

• psteja2000

  Mr or Mrs. 500

  Points: 586

  More actions

  January 10, 2012 at 1:52 pm

  #262686

  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?

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 10, 2012 at 2:50 pm

  #1431444

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

• psteja2000

  Mr or Mrs. 500

  Points: 586

  More actions

  January 10, 2012 at 4:10 pm

  #1431488

  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

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 10, 2012 at 11:09 pm

  #1431574

  What kind of replication do you want to use ?

• psteja2000

  Mr or Mrs. 500

  Points: 586

  More actions

  January 11, 2012 at 2:43 pm

  #1432154

  merge replication with pull subscribers