Unsynchronized tables have foreign keys...

Compares and synchronizes SQL database content.

Unsynchronized tables have foreign keys...

Postby rene1983 » Sun Jun 10, 2012 11:11 pm

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.

Posts: 5
Joined: Sun Jun 10, 2012 11:03 pm

Postby Brian Donahue » Mon Jun 11, 2012 2:12 pm

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
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests