Just trying to use SQL Data Compare for the first time (ver 3.3.7.256), however after selecting the the 2 data sources there are no tables visible to select for comparison?

These are both db's on a local server and I have tried connection as the user and as sa still with no luck. Nothing in the help about permissions required or this problem of no tables to compare

The databases have the same structure as 1 is a subset of the other

Any suggestions
hawk92
0

Comments

1 comment

  • Neil Davidson
    Can you confirm that the tables have a primary key / unique index on them? SQL Data Compare requires one of these to work.

    - Neil
    Neil Davidson
    0

Add comment

Please sign in to leave a comment.