Foreign Key Constraint Error 3726

• buraktuf

  SSC Enthusiast

  Points: 139

  More actions

  November 27, 2008 at 3:50 pm

  #203510

  Hello,

  i need to design a merge replication system between a publiaher and two subscribers. let the name of the db which should be replicated is "DMS". the DMS db should be in the same form as the publisher site at the subscribers. that means the DMS should appear at the subscribers with same relations such foreign keys as the publishers DMS. i've tried to attach the DMS to each subscribers before the replication.so the same relations are on the subscribers. and when i start the replication in this situation i get an error such "table X could not be dropped because it is referenced by a foreign key constraint". also the trancate option also doesnt work. then i have tried to start the replication with newly created dbs on the subscribers. but after the snapshot there is no relations and foreign keys between the tables at the subscribers naturally. however i know that i can create the relation by joining the tables at the filter section. but i have 326 tables which are related to each other in a very complex level. so it doesnt work for my situation. how can i realize this system? is there any way? please help me. thanks for all replies.