Missing Tables
derekbez
Posts: 3
Hey.
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?
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?
Comments
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.