No tables appear when trying to compare

• 
  Hello Richard,
  
  This sounds quite a lot like our most common issue with Data Compare: the fact that it requires primary keys or unique indexes to work properly:
  
  http://www.red-gate.com/messageboard/vi ... .php?t=545

  Brian Donahue June 13, 2005 10:34

  - 0 +
• 
  Hi,
  
  Thanks for the quick response. Some tables do indeed lack primary keys, however, most do not. Do all tables in both databases need to have primary keys?

  rablack June 13, 2005 10:47

  - 0 +
• 
  Hello,
  
  Yes -- or a unique index or unique constraint on the same column. This way, Data Compare can have a basis for matching rows of data together based on a unique row identifier.

  Brian Donahue June 14, 2005 07:54

  - 0 +
• 
  Sorry, what I meant to ask is: do ALL tables need to have primary keys for ANY tables to appear in the comparison selection?

  rablack June 14, 2005 08:14

  - 0 +
• 
  Hi,
  
  No -- tables without primary keys will simply not show up in the list. The rest of them will appear in the list.

  Brian Donahue June 15, 2005 10:25

  - 0 +
• 
  Right, that's what I thought should happen, but I get NO tables at all in the list!

  rablack June 15, 2005 10:30

  - 0 +
• 
  What is your version of Data Compare? >3.8 require that the indexes are identically-named. The next version after that, all you need to do is make sure that the unique index is placed on the same column in both databases.
  
  Also, be aware that tables with different ownership will not be eligible for data compare, and it also checks the name of the primary key or unique index column case-sensitively!

  Brian Donahue June 15, 2005 12:14

  - 0 +

Add comment

Please sign in to leave a comment.