Circular dependency
RicMiller
Posts: 2
Hi there,
I am getting a "Circular dependency" error for two tables when I run the syn wizard in SQL Data Compare.
But I don't see any circular dependency when I "View Dependencies" in SQL Server Management Studio.
Table B has foreign keys to two other tables (A and C), but those two other tables are not dependent on each other.
Table A and B are listed in the warning.
Is there another possible cause of this warning?
Thanks,
Ric Miller
I am getting a "Circular dependency" error for two tables when I run the syn wizard in SQL Data Compare.
But I don't see any circular dependency when I "View Dependencies" in SQL Server Management Studio.
Table B has foreign keys to two other tables (A and C), but those two other tables are not dependent on each other.
Table A and B are listed in the warning.
Is there another possible cause of this warning?
Thanks,
Ric Miller
Comments
I can't comment because I do not know how or if SSMS even tries to detect circular dependencies. From looking at the source code in previous versions, I noticed that our dependency engine checks all relationships on tables and displays this warning. And it is a WARNING in that the synchronization may well work anyway. If dependencies cannot be resolved, however, some operations may occur in the wrong order as SQL Data Compare simply takes the punt and chooses one operation to do first. Please see:
http://www.red-gate.com/MessageBoard/vi ... php?t=4620