How can I resolve a circular dependancy issue?

wendycwendyc Posts: 2
Hi All

I don't really expect an answer tonight, but I'm trying to recover about 4 hours worth of data from a live system and am getting a circular dependancy warning on my data compare. I've got many many rows to push back to the live system ( backup of data after corruption to restored database) Anyone have a script handy that can illuminate where the circularity is?

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your post into the forum.

    Do you have an further information regarding the objects envolved in the circular dependency or dependencies?

    I have known this problem to occur if you have update triggers enabled that cause actions that come back to the original object to be updated.

    If you edit the project and select the options tab. Please enable the options to Disable DML Triggers and Disable DDL Triggers in the Synchronization Behavior Section.

    Hope this helps.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.