No tables in the "Choose Tables" wizard window

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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.
> >
> >
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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 DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.