When syncronizing data I see that WITH NOCHECK is being used a lot when creating the constraints after they have been dropped. Is the add constraint code be created from the current schema or is there a way to specify not to use WITH NOCHECK?
Comments
1 comment
-
Hello,
Data Compare recreates all keys with NOCHECK. This stops the server from checking the data's consistency, going with the assumption that the data should already be in the same state as it was in the source server (consistent or not!)
Add comment
Please sign in to leave a comment.