Missing Tables

derekbezderekbez Posts: 3

Missing a table in Data Compare, in a particular database.

Read the online FAQ. Read the Help. They say the tables must be identical.

I used SQL Compare to copy the tables (actually the entire DB), and it says they are identical. I've checked manually as best I can, and they look the same to me. Same fields, same structure, same users as all the other tables...

At first I thought I had found a bug because it happens to be the very last table in the db. Not likely though. :)

Any ideas?


  • Actually there are about 10 tables missing, as I've just found out by doing a manual count.
  • Brian DonahueBrian Donahue Posts: 6,590 New member

    The primary key solution is the short answer. The long answer is that the column names need to match (case sensitively) and the collation order should be the same. It could also be that you have changed the schema between comparisons and the columns aren't appearing because of the cached selections from your previous comparison.
Sign In or Register to comment.