cascade delete
Brian Donahue
Posts: 6,590 Bronze 1
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.
Regards,
Brian Donahue
Red Gate Technical Support
"Patrick Reijnders" <p.reijnders@xl21.nl> wrote in message
news:Or1aXscfDHA.1488@server53...
> Hi,
>
> I've already looked into the FAQ for this, but the fix suggested there
does
> 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',
which
> I did.
>
> What else can I do?
>
> Thanx,
>
> 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.
Regards,
Brian Donahue
Red Gate Technical Support
"Patrick Reijnders" <p.reijnders@xl21.nl> wrote in message
news:Or1aXscfDHA.1488@server53...
> Hi,
>
> I've already looked into the FAQ for this, but the fix suggested there
does
> 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',
which
> I did.
>
> What else can I do?
>
> Thanx,
>
> Patrick
>
>
This discussion has been closed.
