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

FKs not dropped before PKs

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 10:04AM in SQL Compare Previous Versions
Hi JW,

You're 100% correct. This is a known issue and it's been fixed for the
upcoming release that you can look forward to in two weeks or so.


Brian Donahue
Red Gate Technical Support

"JW" <sorrynospam@nospamforme.com> wrote in message
> A point of clarification. The FK constraints reference and therefore are
> dependent upon the PK constraint that is being dropped. So the script
> fails.
> "JW" <sorrynospam@nospamforme.com> wrote in message
> news:793ms4W8DHA.2200@server53...
> > I'm evaluating SQL Compare I performed a complete compare
> > discovered differences in the primary key constraint names. The synch
> > script that was created failed to drop the Foreign Key constraints prior
> to
> > dropping and recreating the PK constraints. The option to "include
> > dependent database objects" was selected.
> >
> > I thought I saw a previous acknowledgement on this forum that this was a
> > known issue--but can no longer find that thread. If this is a known
> issue,
> > do you have an estimate on when a fix might be available.
> >
> > Thanks!
> >
> >


This discussion has been closed.