SQL DATA COMPARE - Where are the tables?

mkovas

I am trying to do a DATA Compare. I am able to select the servers and the databases using a standard account(SA). However, when I click next I do not see any tables listed. If I select Compare, it tells me to select at least one table. Where are the tables? I can not select a table if they are not in the list.

Thanks,
Mike

Brian Donahue

Hello Mike,

This is definitely a schema-related issue or because of the absence of one or more primary keys on the tables. Please have a look at this other article from our forums for a list of causes and possible fix actions.

http://www.red-gate.com/messageboard/vi ... .php?t=545