Disabling a Check Constraint for Replication

See Also

You can disable a check constraint when your table is replicated in another database. When you replicate a table, the table definition and data are copied from the source database to a destination database. These two databases are usually (but not necessarily) on separate servers. If the check constraints are specific to the source database, they may unnecessarily prevent new data from being entered in the destination database.

Note   Some databases have different functionality for check constraints. For more information about the differences between databases, see Database Server Considerations. Consult your database documentation for details about how your database works with check constraints.

To disable a check constraint for replication

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

When you replicate a database at a remote site, you should not re-apply check constraints because:

• The integrity of the data was checked when it was entered into the original database.
  
  
• The replication will fail if data violates the check constraints.