What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare 8 referential integrity constraints error

mohdabdulazeemmohdabdulazeem Posts: 2
edited December 9, 2009 2:38AM in SQL Compare Previous Versions
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.
Mohd.Abdul Azeem
DBA
MCTS SQL Server 2005
Sign In or Register to comment.