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

cascade delete

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 18, 2003 9:26AM in SQL Compare Previous Versions
Hi Patrick,

Thanks for posting to the newsgroup. In your case, you would also want
to make sure that the option 'Include Keys' is selected. If it isn't, the
software will not compare your foriegn keys at all.


Brian Donahue
Red Gate Technical Support

"Patrick Reijnders" <p.reijnders@xl21.nl> wrote in message
> Hi,
> I've already looked into the FAQ for this, but the fix suggested there
> not work.
> I have two SQL 2000 databases with some CASCADE DELETE relationships, but
> the SQL Compare does not see any differences.
> In the FAQ it was stated to disable 'Create SQL 7 compatible scripts',
> I did.
> What else can I do?
> Thanx,
> Patrick
This discussion has been closed.