No Tables to Choose From

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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" <greddin@komen.org> wrote in message
news:g4WWhMYmDHA.1480@server53...
> 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 Bronze 1
    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" <florusse@xs4all.nl> wrote in message
    news:WGMZbcDpDHA.1492@server53...
    > 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)" <brian.donahue@red-gate.com> wrote in message
    > news:BrLhixWnDHA.548@server53...
    > > 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" <greddin@komen.org> wrote in message
    > > news:g4WWhMYmDHA.1480@server53...
    > > > 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 Bronze 1
    Hi John,

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

    Brian Donahue
    Red Gate Technical Support


    "JohnWayne" <jpatches23@%%NOSPAM%%hotmail.com> wrote in message
    news:3Zvor0$7DHA.2540@server53...
    > Also, there are some tables that I know have the exact same structure.
    >
    > "JohnWayne" <jpatches23@%%NOSPAM%%hotmail.com> wrote in message
    > news:mPn15x$7DHA.1628@server53...
    > > 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)" <brian.donahue@red-gate.com> wrote in message
    > > news:XK59aiUpDHA.1500@server53...
    > > > 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" <florusse@xs4all.nl> wrote in message
    > > > news:WGMZbcDpDHA.1492@server53...
    > > > > 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)" <brian.donahue@red-gate.com> wrote in
    > message
    > > > > news:BrLhixWnDHA.548@server53...
    > > > > > 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" <greddin@komen.org> wrote in message
    > > > > > news:g4WWhMYmDHA.1480@server53...
    > > > > > > 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.