Disabling a Foreign Key Constraint for Replication
SQL Server supports 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
In your database diagram, right-click the table containing the foreign key, then select Properties from the shortcut menu.
-or-
Open the Table Designer for the table containing the foreign key you want to modify, right-click in the Table Designer, and choose Properties from the shortcut menu.
Choose the Relationships tab.
Select the relationship from the Selected relationship list.
Clear the Enable relationship for replication check box.