Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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?
Title: Unsynchronized tables have foreign keys to table [dbo].[CompanyPolicyCustom]; the database may be left in an inconsistent state.
- Posts: 5
- Joined: Mon Jun 11, 2012 12:03 am
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).
- 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 0 guests