Unsynchronized tables have foreign keys...

[rene1983]

First, when I try to access the help for the Data Compare, I get a 404 browser error.

Secondly, I'm trying to sync the data between two databases and I'm getting this warning when running the deployment wizard. What does it mean? What is causing it? How can I get rid of it?

Severity: Medium
Object: CompanyPolicyCustom
Title: Unsynchronized tables have foreign keys to table [dbo].[CompanyPolicyCustom]; the database may be left in an inconsistent state.

Thanks!!!

[Brian Donahue]

SQL Data Compare detects that a table has a foreign key and then it shows you this warning when only one of the two tables are included in the comparison. If you know this will not cause a problem, please do not worry about it and synchronize the table. The recommendation is to synchronize both tables so that the foreign key relationship will be enforced.

Sometimes the warning will not be resolved if there are circular references (tableA->tableB->tableC->tableA).
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521