Missing table in "CreateFromIntersection"

ampoampo Posts: 16
Hello.

After getting Source DB tables and Target DB tables, I user CreateFromIntersection to get list of tables from both.

I have a table that 100% exists in both but it isn't in the result list...

Any idea why it isn't there?

Thanks.

Comments

  • Thanks for your post.

    Does the table have a primary key, unique index or unique constraint?

    If it doesn't, then SQL Data Compare cannot automatically map the tables, so you will need to manually choose a comparison key for this table.

    I hope this helps.
    Chris
Sign In or Register to comment.