How can we help you today? How can we help you today?

Sync Warning for Circular Dependencies

Can anyone tell me why I'm seeing this error? What exactly does this mean and how much of a problem is it?
mohaaron
0

Comments

1 comment

Sort by
  • richardjm
    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.
    richardjm
    0

Add comment

Please sign in to leave a comment.