SDC 3 - No tables visible in table list
Brian Donahue
Posts: 6,590 Bronze 1
- Date: 7 Oct 2004
- Reviewed: 26 April 2005
- Versions affected: 3.0-3.38
In the second screen of the compare wizard, you are presented with a dialog to select the tables that you can choose to compare. This list can possibly be empty or missing a few tables.
This happens because the table schema does not match or is incompatible with Data Compare's row matching algorithm. Please check the following on the table(s) in both databases:
- The tables have a primary key or unique index
- The table names match and have the same owner (the match is case-sensitive)
- The column names that the unique constraint is applied to have the same case-sensitive name
Because Data Compare does a case-sensitive check of the schema before marking the tables as eligable for comparison, the tables may be incompatible and therefore ignored by Data Compare.
From version 3.3.9, SQL Data Compare does not require the unique index used as a comparison key to be identically-named between the two databases.
