No tables in the "Choose Tables" wizard window

Brian Donahue

Hi David,

First, you should check to see that both tables have primary keys
defined. In addition to that, the primary key constraints have to be named
identically, and case-sensitively at that!

Kind Regards,

Brian Donahue
Red Gate Technical Support

"David Pendleton" <david.pendleton@pattersondental.com> wrote in message
news:Ekioe39$DHA.1468@server53...
> Same problem here. Same table, different servers and database names...
>
> Anyone have any ideas?
>
> "Chuck Hergenroeder" <chergenroeder@ptmarketing.com> wrote in message
> news:R5CxnFN$DHA.1592@server53...
> > I am attempting to compare 2 databases on 2 different servers. The
table
> > structures are identical however after I choose the databases and click
> next
> > in the wizard there are no tables displayed in the "Choose Tables"
wizard.
> >
> >
>
>

Brian Donahue

Hi Dave,

I didn't mention that they need to have the same owner as well. If this
pans out, then by all means send us a SQL script of the tables and we'll try
to reproduce and fix the problem.

Regards,

Brian Donahue
Red Gate Technical Support

"Dave Sueltenfuss" <dave.sueltenfuss@arch.com> wrote in message
news:pLbs1hRBEHA.1468@server53...
> I am having a similar issue. I am comparing two identical DB's and all of
> the tables, except for this one, are showing up on the Choose Tables
Window.
> I have confirmed that the table has the same PK on both DB's.
>
> Any ideas?
>
> Dave Sueltenfuss
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:1hatpbFAEHA.1220@server53...
> > Hi David,
> >
> > First, you should check to see that both tables have primary keys
> > defined. In addition to that, the primary key constraints have to be
named
> > identically, and case-sensitively at that!
> >
> > Kind Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "David Pendleton" <david.pendleton@pattersondental.com> wrote in message
> > news:Ekioe39$DHA.1468@server53...
> > > Same problem here. Same table, different servers and database names...
> > >
> > > Anyone have any ideas?
> > >
> > > "Chuck Hergenroeder" <chergenroeder@ptmarketing.com> wrote in message
> > > news:R5CxnFN$DHA.1592@server53...
> > > > I am attempting to compare 2 databases on 2 different servers. The
> > table
> > > > structures are identical however after I choose the databases and
> click
> > > next
> > > > in the wizard there are no tables displayed in the "Choose Tables"
> > wizard.
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Brian Donahue

Hi Stephane,

I've tested this out here and it doesn't seem to be the case. Data
Compare checks the constraint name and the column that it's on, so I was
even able to compare a table with a unique index called PK_TableName with a
table that had a primary key constraint called PK_TableName. The order
didn't seem to make any difference.

Regards,

Brian Donahue
Red Gate Technical Support

"Stephane Lagace" <stephane.lagace@buroplus.ca> wrote in message
news:6X5yFYuUEHA.1512@server53...
> I have the same problem.
> Tables are the same in all aspect.
>
> The only difference I can note is when designing the table in Enterprise
> manager. In one database in the properties and on the index tab the
> selected index shown at first in not the same than the other.
>
> While the same indexes are present with same options and fields it seems
> they have not been created in the same order (my guess).
>
> Hope this helps!
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> a écrit dans le
> message de news: b6gVNyTBEHA.2768@server53...
> > Hi Dave,
> >
> > I didn't mention that they need to have the same owner as well. If
> this
> > pans out, then by all means send us a SQL script of the tables and we'll
> try
> > to reproduce and fix the problem.
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Dave Sueltenfuss" <dave.sueltenfuss@arch.com> wrote in message
> > news:pLbs1hRBEHA.1468@server53...
> > > I am having a similar issue. I am comparing two identical DB's and all
> of
> > > the tables, except for this one, are showing up on the Choose Tables
> > Window.
> > > I have confirmed that the table has the same PK on both DB's.
> > >
> > > Any ideas?
> > >
> > > Dave Sueltenfuss
> > >
> > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in
message
> > > news:1hatpbFAEHA.1220@server53...
> > > > Hi David,
> > > >
> > > > First, you should check to see that both tables have primary
keys
> > > > defined. In addition to that, the primary key constraints have to be
> > named
> > > > identically, and case-sensitively at that!
> > > >
> > > > Kind Regards,
> > > >
> > > > Brian Donahue
> > > > Red Gate Technical Support
> > > >
> > > > "David Pendleton" <david.pendleton@pattersondental.com> wrote in
> message
> > > > news:Ekioe39$DHA.1468@server53...
> > > > > Same problem here. Same table, different servers and database
> names...
> > > > >
> > > > > Anyone have any ideas?
> > > > >
> > > > > "Chuck Hergenroeder" <chergenroeder@ptmarketing.com> wrote in
> message
> > > > > news:R5CxnFN$DHA.1592@server53...
> > > > > > I am attempting to compare 2 databases on 2 different servers.
> The
> > > > table
> > > > > > structures are identical however after I choose the databases
and
> > > click
> > > > > next
> > > > > > in the wizard there are no tables displayed in the "Choose
Tables"
> > > > wizard.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>