Disabling a Foreign Key Constraint for Replication
See Also
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
-
In your database diagram, select the table that the foreign key constraint is attached to.
-
Right-click the table and select Properties.
-
Choose the Relationships tab.
-
Select the relationship from the Selected relationship list.
-
Clear the Enable relationship for replication check box.