Disable a Foreign Key Constraint for Replication

Microsoft 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.

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, right-click the table containing the foreign key, then select Properties from the shortcut menu.
3. Choose the Relationships tab.
4. Select the relationship from the Selected relationship list.
5. Clear the Enforce relationship for replication check box.