Unsynchronized tables have foreign keys...

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Unsynchronized tables have foreign keys...

Postby rene1983 » Mon Jun 11, 2012 12:11 am

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!!!
rene1983
 
Posts: 5
Joined: Mon Jun 11, 2012 12:03 am

Postby Brian Donahue » Mon Jun 11, 2012 3: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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest