No tables in the "Choose Tables" wizard window

• 
  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 March 08, 2004 13:39

  - 0 +
• 
  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.
  > > > > > >
  > > > > > >
  > > > > >
  > > > > >
  > > > >
  > > > >
  > > >
  > > >
  > >
  > >
  >
  >

  Brian Donahue June 18, 2004 11:23

  - 0 +

Add comment

Please sign in to leave a comment.