Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Comments
You may want to try the 'disable foriegn keys' option if you are going to synchronize both thbles in the relationship using Data Compare. That should normalize the data so that these errors don't occur.