Options
can select unique constraints as key column
Brian Donahue
Posts: 6,590 Bronze 1
Hi Guy,
Data Compare supports unique indexes, but not unique constraints. There
is a subtle difference there. As far as I know, we should be able to support
columns which have unique constraints placed on them, but the idea is still
in the suggestion box as I write this.
Regards,
Brian Donahue
Red Gate Technical Support
"guy rafalovich" <guyr@hotbar.com> wrote in message
news:gqHwl$RMEHA.3088@server53...
> Hello
>
> I have installed the new version 3.5.5, a found that there is a missing
> feature from the former version.
> I can't select a unique constraint to be the key index to compare the two
> tables with.
>
> Is that a feature?
> Am i missing an option?
>
> do i have to change the definition from unique constraint to unique index
?
>
>
> Guy Rafalovich
> DBA Team Leader
> HotBar.Com
>
>
>
>
Data Compare supports unique indexes, but not unique constraints. There
is a subtle difference there. As far as I know, we should be able to support
columns which have unique constraints placed on them, but the idea is still
in the suggestion box as I write this.
Regards,
Brian Donahue
Red Gate Technical Support
"guy rafalovich" <guyr@hotbar.com> wrote in message
news:gqHwl$RMEHA.3088@server53...
> Hello
>
> I have installed the new version 3.5.5, a found that there is a missing
> feature from the former version.
> I can't select a unique constraint to be the key index to compare the two
> tables with.
>
> Is that a feature?
> Am i missing an option?
>
> do i have to change the definition from unique constraint to unique index
?
>
>
> Guy Rafalovich
> DBA Team Leader
> HotBar.Com
>
>
>
>
This discussion has been closed.
Comments
There is a new version of Data Compare, just out today, which has
support for unique constraints in it. If you perform a 'check for updates'
from the help menu, you should get the updated software.
Regards,
Brian Donahue
Red Gate Technical Support
"guy rafalovich" <guyr@hotbar.com> wrote in message
news:E3idtE2MEHA.1512@server53...
> Hi Brian
>
> I think that you should know that before the upgrade it was possiable to
> use unique constraints. I have installed the former version back to make
> sure i'm not mistaken.
>
> I really hope you can add the request fast, since im using alot of
unique
> constraints in my DB.
>
>
>
> Guy Rafalovich
> DBA Team Leader
> HotBar.Com
> tell +972-36012250
> Fax +972-36025225
> guyr@hotbar.com
>
>
>
>
> Add this card to your address book
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:yxZprErMEHA.1512@server53...
> > Hi Guy,
> >
> > Data Compare supports unique indexes, but not unique constraints.
> There
> > is a subtle difference there. As far as I know, we should be able to
> support
> > columns which have unique constraints placed on them, but the idea is
> still
> > in the suggestion box as I write this.
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> >
> > "guy rafalovich" <guyr@hotbar.com> wrote in message
> > news:gqHwl$RMEHA.3088@server53...
> > > Hello
> > >
> > > I have installed the new version 3.5.5, a found that there is a
> missing
> > > feature from the former version.
> > > I can't select a unique constraint to be the key index to compare
the
> two
> > > tables with.
> > >
> > > Is that a feature?
> > > Am i missing an option?
> > >
> > > do i have to change the definition from unique constraint to unique
> index
> > ?
> > >
> > >
> > > Guy Rafalovich
> > > DBA Team Leader
> > > HotBar.Com
> > >
> > >
> > >
> > >
> >
> >
>
>
>
--
> ----
>
>
>
>