Unsynchronized tables have foreign keys...

rene1983rene1983 Posts: 8 Bronze 1
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!!!

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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).
Sign In or Register to comment.