No Tables to Choose From
Brian 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
>
>
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.
Comments
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
> > >
> > >
> >
> >
>
>
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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>