Sync Warning for Circular Dependencies

mohaaronmohaaron Posts: 46
edited April 3, 2007 4:38AM in SQL Data Compare Previous Versions
Can anyone tell me why I'm seeing this error? What exactly does this mean and how much of a problem is it?
· Share on Twitter

Comments

  • richardjmrichardjm Posts: 598
    This happens when you have foreign keys created in such a way that there is a circular reference. So that you will have a database that looks something like..

    Table_A has a foreign key to Table_B
    Table_B has a foreign key to Table_C
    Table_C has a foreign key to Table_A

    I'd be very wary of synchronising data in these circumstances and thoroughly review your database schema. Have a look at SQL Dependency Tracker (ok I would say that wouldn't I :) ) http://www.red-gate.com/products/SQL_De ... /index.htm. This will give you a visual representation of your database and may help you track down any issues you have.

    Hope this helps.
    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
    · Share on Twitter
Sign In or Register to comment.