Disabling a Foreign Key Constraint for Replication

Select the option to disable a foreign key constraint during replication if the constraint is specific to the source database and may unnecessarily prevent new data from being entered into the destination database.

To disable a foreign key constraint for replication

1. In your database diagram, select the table that the foreign key constraint is attached to.
   
   
2. Right-click the table and select Properties.
   
   
3. Choose the Relationships tab.
   
   
4. Select the relationship from the Selected relationship list.
   
   
5. Clear the Enable relationship for replication check box.