How can we help you today? How can we help you today?

can select unique constraints as key column

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
>
>
>
>
Brian Donahue
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi Guy,

    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
    > > >
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
    >
    --
    > ----
    >
    >
    >
    >
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.