No Tables to Choose From

Brian DonahueBrian Donahue Posts: 6,590 New member
Hi Gregory,

This is a fairly common problem. It happens because the tables aren't
close enough in schema to be able to be compared. In addition to having one
or more matching columns, you'll need at least one primary key or unique
index and -- here's the kicker -- the index names and Primary Key names have
to match!

Regards,

Brian Donahue
Red Gate Technical Support

"Gregory Reddin" <[email protected]> wrote in message
news:[email protected]
> I just installed SQL Data Compare. When I run it, I choose the two
databases
> and press the "Next" button. But I do not see any tables listed to choose
> from.
>
> Please help.
>
> -Gregory Reddin
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Bart,

    Unfortunately, there is nothing you can do at this time. If a table has
    a matching name, but a different owner, it's treated as a different object
    as per the naming convention of SQL Server.

    Kind Regards,

    Brian Donahue

    Red Gate Technical Support

    "Bart Florusse" <[email protected]> wrote in message
    news:[email protected]
    > I have the same problem but I guess it's because my "live" tables have
    > another owner name than my local tables. How can I solve that?
    >
    > Regards
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi Gregory,
    > >
    > > This is a fairly common problem. It happens because the tables
    aren't
    > > close enough in schema to be able to be compared. In addition to having
    > one
    > > or more matching columns, you'll need at least one primary key or unique
    > > index and -- here's the kicker -- the index names and Primary Key names
    > have
    > > to match!
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Gregory Reddin" <[email protected]> wrote in message
    > > news:[email protected]
    > > > I just installed SQL Data Compare. When I run it, I choose the two
    > > databases
    > > > and press the "Next" button. But I do not see any tables listed to
    > choose
    > > > from.
    > > >
    > > > Please help.
    > > >
    > > > -Gregory Reddin
    > > >
    > > >
    > >
    > >
    >
    >
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi John,

    And what about the Primary Key constraint names? Are they the same as
    well?

    Brian Donahue
    Red Gate Technical Support


    "JohnWayne" <[email protected]%%NOSPAM%%hotmail.com> wrote in message
    news:[email protected]
    > Also, there are some tables that I know have the exact same structure.
    >
    > "JohnWayne" <[email protected]%%NOSPAM%%hotmail.com> wrote in message
    > news:[email protected]
    > > Hi Brian,
    > >
    > > I have the same problem, however I don't know if I am doing something
    > wrong.
    > > we have 2 versions of the DB, and the only difference is that some
    tables
    > > have an additional column [ColumnX]
    > > DB 1 does not have this column, and DB2 does.
    > >
    > > They are originally MS access DB, imported to SQL Server, using DTS. So
    > > therefore they would have the dB owner.
    > >
    > > Any thoughts
    > >
    > > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > > news:[email protected]
    > > > Hi Bart,
    > > >
    > > > Unfortunately, there is nothing you can do at this time. If a
    table
    > > has
    > > > a matching name, but a different owner, it's treated as a different
    > object
    > > > as per the naming convention of SQL Server.
    > > >
    > > > Kind Regards,
    > > >
    > > > Brian Donahue
    > > >
    > > > Red Gate Technical Support
    > > >
    > > > "Bart Florusse" <[email protected]> wrote in message
    > > > news:[email protected]
    > > > > I have the same problem but I guess it's because my "live" tables
    have
    > > > > another owner name than my local tables. How can I solve that?
    > > > >
    > > > > Regards
    > > > >
    > > > > "Brian Donahue (Red Gate)" <[email protected]> wrote in
    > message
    > > > > news:[email protected]
    > > > > > Hi Gregory,
    > > > > >
    > > > > > This is a fairly common problem. It happens because the tables
    > > > aren't
    > > > > > close enough in schema to be able to be compared. In addition to
    > > having
    > > > > one
    > > > > > or more matching columns, you'll need at least one primary key or
    > > unique
    > > > > > index and -- here's the kicker -- the index names and Primary Key
    > > names
    > > > > have
    > > > > > to match!
    > > > > >
    > > > > > Regards,
    > > > > >
    > > > > > Brian Donahue
    > > > > > Red Gate Technical Support
    > > > > >
    > > > > > "Gregory Reddin" <[email protected]> wrote in message
    > > > > > news:[email protected]
    > > > > > > I just installed SQL Data Compare. When I run it, I choose the
    two
    > > > > > databases
    > > > > > > and press the "Next" button. But I do not see any tables listed
    to
    > > > > choose
    > > > > > > from.
    > > > > > >
    > > > > > > Please help.
    > > > > > >
    > > > > > > -Gregory Reddin
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.