SQL Compare 8 referential integrity constraints error

mohdabdulazeem

Hi

I am using SQL Compare 8.1. When I am generating sync scripts I am getting few issues.
example:

Tables: a,b,c,d,e,f

Table a references table b, table c references table d.

Table e references table a, table f references table b.

When I am generating scripts for dropping tables a and c the constraints between a and b and c and d are getting dropped.

When I execute the script i am getting referential integrity constraints error between tables e and a and f and c.

Any help on this will be immensely Appreciated.