can select unique constraints as key column

Brian DonahueBrian Donahue Posts: 6,590 New member
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" <[email protected]> wrote in message
news:[email protected]
> 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
>
>
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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" <[email protected]> wrote in message
    news:[email protected]
    > 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
    > [email protected]
    >
    >
    >
    >
    > Add this card to your address book
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > 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" <[email protected]> wrote in message
    > > news:[email protected]
    > > > 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.