Replicating child table but not the parent table

Question

Post reply

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?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

azdzn SSCarpal Tunnel Points: 4128 More actions · Answer 1

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

psteja2000 Mr or Mrs. 500 Points: 586 More actions · Answer 2

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